鍦ㄦ暟鎹簱涓紝CHECK绾︽潫鐢ㄤ簬闄愬埗鐗瑰畾鍒楃殑鍙栧€艰寖鍥淬€傚畠瀹氫箟浜嗕竴涓潯浠讹紝鍙湁婊¤冻璇ユ潯浠剁殑鍊兼墠鑳借鎻掑叆鎴栨洿鏂板埌璇ュ垪涓€?br/>鍦ㄥ垱寤鸿〃鏃讹紝鍙互浣跨敤CHECK绾︽潫鏉ヨ缃潯浠躲€備互涓嬫槸浣跨敤CHECK绾︽潫鐨勫熀鏈娉曪細

CREATE TABLE 琛ㄥ悕 (
聽聽聽聽鍒楀悕聽鏁版嵁绫诲瀷,
聽聽聽聽CHECK聽(鏉′欢)
);

渚嬪锛屽垱寤轰竴涓悕涓?quot;students"鐨勮〃锛岃姹傛垚缁╁湪0鍒?00涔嬮棿锛?br/>

CREATE聽TABLE聽students聽(

聽聽聽聽id聽INT聽PRIMARY聽KEY,
聽聽聽聽name聽VARCHAR(50),
聽聽聽聽score聽INT聽CHECK聽(score聽>=聽0聽AND聽score聽<=聽100)
);

鍦ㄤ笂闈㈢殑渚嬪瓙涓紝CHECK绾︽潫鎸囧畾浜嗘垚缁╁繀椤诲ぇ浜庣瓑浜?涓斿皬浜庣瓑浜?00銆?br/>杩樺彲浠ュ湪宸插瓨鍦ㄧ殑琛ㄤ腑娣诲姞CHECK绾︽潫銆備娇鐢ˋLTER TABLE璇彞锛屽皢CHECK绾︽潫娣诲姞鍒拌〃鐨勫垪涓娿€備互涓嬫槸娣诲姞CHECK绾︽潫鐨勫熀鏈娉曪細

ALTER聽TABLE聽琛ㄥ悕
ADD聽CHECK聽(鏉′欢);

渚嬪锛屼负"students"琛ㄧ殑score鍒楁坊鍔燙HECK绾︽潫锛?br/>

ALTER聽TABLE聽students
ADD聽CHECK聽(score聽>=聽0聽AND聽score聽<=聽100);

鍦ㄤ笂闈㈢殑渚嬪瓙涓紝CHECK绾︽潫鎸囧畾浜嗘垚缁╁繀椤诲ぇ浜庣瓑浜?涓斿皬浜庣瓑浜?00銆?br/>鎬荤粨锛欳HECK绾︽潫鐢ㄤ簬闄愬埗鎸囧畾鍒楃殑鍙栧€艰寖鍥达紝鍙互鍦ㄥ垱寤鸿〃鏃舵垨鍦ㄥ凡瀛樺湪鐨勮〃涓婃坊鍔燙HECK绾︽潫銆?br/>