Question

mysql执行sql语句时报错！！应该怎么解决？

我的sql语句是：UPDATE personal SET user_name ='孙浩6',family_id = '00000203',generation = '2',ranking = '26',PASSWORD = '' permission = '9' WHERE id = '11' LIMIT 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'permission = '9' where id = '11' limit 1' at line 1

Answer 1

PASSWORD = '' permission = '9'这里错了，他俩之间缺个“，”号
UPDATE personal SET user_name ='孙浩6',family_id = '00000203',generation = '2',ranking = '26',PASSWORD = '',permission = '9' WHERE id = '11' LIMIT 1

这样试试

Answer 2

PASSWORD = '' permission = '9'

中间的逗号哪去了，是不是
PASSWORD = '' ,permission = '9'

Answer 3

少了个逗号

UPDATE personal SET user_name ='孙浩6',family_id = '00000203',generation = '2',ranking = '26',PASSWORD = '', permission = '9' WHERE id = '11' LIMIT 1

Answer 4

SQL 更新语句有问题 不应该使用limit 你这是更新不是查询 估计是这样

Answer 5

查看字段类型是否匹配。