nacivat鎬庝箞璁剧疆澶栭敭
鍦∟acivat涓紝鍙互浣跨敤浠ヤ笅鏂规硶鏉ヨ缃閿細
1. 鍦ㄩ渶瑕佽缃閿殑琛ㄤ腑鍒涘缓涓€涓垪锛岀敤浜庡瓨鍌ㄥ閿殑鍊笺€傚彲浠ヤ娇鐢╜FOREIGN KEY`鍏抽敭瀛楁潵鎸囧畾璇ュ垪鏄竴涓閿垪銆?br/>
CREATE TABLE 琛ㄥ悕 (聽聽聽鍒?聽鏁版嵁绫诲瀷,
聽聽聽鍒?聽鏁版嵁绫诲瀷,
聽聽聽鈥?/p>
聽聽聽澶栭敭鍒椔犳暟鎹被鍨?
聽聽聽FOREIGN聽KEY聽(澶栭敭鍒?聽REFERENCES聽鍙傜収琛ㄥ悕(鍙傜収琛ㄥ垪) );
2. 纭繚鍙傜収琛ㄤ腑瀛樺湪琚紩鐢ㄧ殑鍒楋紝骞朵笖璇ュ垪鏄竴涓富閿垨鏈夊敮涓€绾︽潫銆?br/>3. 鍦ㄥ弬鐓ц〃鐨勮寮曠敤鍒椾笂鍒涘缓绱㈠紩锛屼互鎻愰珮鏌ヨ鎬ц兘銆?br/>
CREATE聽INDEX聽绱㈠紩鍚嵚燨N聽鍙傜収琛ㄥ悕(琚紩鐢ㄥ垪);
4. 褰撳悜涓昏〃鎻掑叆鏁版嵁鏃讹紝纭繚澶栭敭鍒楃殑鍊煎瓨鍦ㄤ簬鍙傜収琛ㄧ殑琚紩鐢ㄥ垪涓€?br/>濡傛灉澶栭敭鍒楃殑鍊间笉鍦ㄥ弬鐓ц〃鐨勮寮曠敤鍒椾腑锛屽皢浼氬鑷存彃鍏ュけ璐ュ苟鎶涘嚭寮傚父銆?br/>5. 鏍规嵁闇€瑕侊紝鍙互浣跨敤ON DELETE
鍜?code>ON UPDATE鍏抽敭瀛楁潵鎸囧畾鍒犻櫎鎴栨洿鏂板弬鐓ц鏃剁殑鎿嶄綔銆備緥濡傦細
FOREIGN聽KEY聽(澶栭敭鍒?聽REFERENCES聽鍙傜収琛ㄥ悕(鍙傜収琛ㄥ垪)聽ON聽DELETE聽CASCADE聽ON聽UPDATE聽CASCADE
涓婅堪绀轰緥涓紝褰撳弬鐓ц〃涓殑琛岃鍒犻櫎鎴栨洿鏂版椂锛屼笌涔嬪叧鑱旂殑澶栭敭琛屼篃浼氳鍒犻櫎鎴栨洿鏂般€?br/>浠ヤ笂鏄湪Nacivat涓缃閿殑涓€鑸楠ゅ拰璇硶銆傝娉ㄦ剰锛屽叿浣撶殑璁剧疆鏂规硶鍙兘浼氬洜鏁版嵁搴撶鐞嗙郴缁熺殑鐗堟湰鍜屽疄鐜拌€屾湁鎵€涓嶅悓銆?br/>