更新表:
update table_name set field1 = new_value1 , field2 = new_value2;
结果:
同时更新多张表的数据:
update table_name1 , table_name2 , ... , table_nameN
set
t1.field = expr1 , ... , fieldN = exprN [where clause]
更新表:
update table_name set field1 = new_value1 , field2 = new_value2;
结果:
同时更新多张表的数据:
update table_name1 , table_name2 , ... , table_nameN
set
t1.field = expr1 , ... , fieldN = exprN [where clause]