问题如下 : 表: userinfo
update userinfo set username = '123' , set re = '123' where uid = 3; username, re 都为varchar型。
执行这条语句会报错
如果只更新一个字段,则可以正常更新, 多个字段则不行, 帮忙看看哦~!~
update userinfo set username = '123' , set re = '123' where uid = 3; username, re 都为varchar型。
执行这条语句会报错
如果只更新一个字段,则可以正常更新, 多个字段则不行, 帮忙看看哦~!~
SET col_name1=expr1 [, col_name2=expr2 ...]
[WHERE where_definition]
[ORDER BY ...]
[LIMIT row_count]Multiple-table语法:UPDATE [LOW_PRIORITY] [IGNORE] table_references
SET col_name1=expr1 [, col_name2=expr2 ...]
[WHERE where_definition]