update更新記錄

1.基礎(chǔ)語法

UPDATE table_name SET column1 = value1, column2 = value2...., columnN = valueN WHERE [condition];

2.多表聯(lián)合更新記錄

upate "A" set "A字段" = B."字段" from "B" where "A字段" = B."字段" 或

upate "A" set "A字段" = B."字段" from "B" where A."字段" = B."字段" 例1：

UPDATE "ZP01_copy" SET "建制村人口" = B."總?cè)丝跀?shù)" , "自然村數(shù)量" = B."自然村數(shù)" FROM "WPS表格" B WHERE left("鄉(xiāng)鎮(zhèn)名稱",1)= left(B."鄉(xiāng)（鎮(zhèn)）",1) AND left("建制村名稱",1)= left(B."村",1) AND "建制村人口" = '' AND "建制村名稱" != '大村委會(huì)' AND "建制村名稱" != '小村委會(huì)'

例2：

UPDATE "ZP1" A SET "通達(dá)路線編碼" = B."通達(dá)路線編碼" FROM "Z02" B WHERE A."鄉(xiāng)鎮(zhèn)名稱" = B."鄉(xiāng)鎮(zhèn)名稱" AND A."建制村名稱"= B."建制村名稱" AND A."通達(dá)路線編碼" = ''