发表于 2009-1-5 19:48
| 
SQL璇硶 UPDATE
鍙戝竷: 2008-7-01 14:16 | 浣滆: 缃戠粶杞浇 | 鏉ユ簮: 缃戠粶杞浇 | 鏌ョ湅: 23娆
SQL璇硶 UPDATE
UPDATE
sql-statement ::=
UPDATE [ OR conflict-algorithm ] [database-name .] table-name
SET assignment [, assignment]*
[WHERE expr]
assignment ::=
column-name = expr
UPDATE璇彞鐢ㄤ簬鏀瑰彉琛ㄤ腑鎵閫夎鐨勫瓧娈靛笺傛瘡涓猆PDATE鐨勮祴鍊肩殑绛夊彿宸﹁竟涓哄瓧娈靛悕鑰屽彸杈逛负浠绘剰琛ㄨ揪寮忋傝〃杈惧紡鍙互浣跨敤鍏跺畠瀛楁鐨勫笺傛墍鏈夌殑琛ㄨ揪寮忓皢鍦ㄨ祴鍊间箣鍓嶆眰鍑虹粨鏋溿傚彲浠ヤ娇鐢╓HERE瀛愬彞闄愬畾闇瑕佹敼鍙樼殑琛屻
鍦ㄤ娇鐢ㄨ繖涓鍛戒护鏃讹紝鍒╃敤鍙夌殑ON CONFLICT瀛愬彞鍙互瀹氫箟鏇夸唬鐨勭害鏉熷啿绐佸垽瀹氱畻娉曘傛洿澶氫俊鎭紝鍙傝 ON CONFLICT銆
