在用SQLyog执行sql语句时报错!求大神帮忙看下,该如何处理
程序员文章站
2022-05-18 17:57:58
...
在用SQLyog执行sql语句时报错!!求大神帮忙看下
我的sql语句是:UPDATE personal SET user_name ='孙浩6',family_id = '00000203',generation = '2',ranking = '26',PASSWORD = '' permission = '9' WHERE id = '11' LIMIT 1
错误代码: 1064
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
------解决思路----------------------
permission 前面少了个逗号也看不出来吗?
错误信息已经明确的告诉你在解析到 'permission = '9' where id = '11' limit 1' 时出现了问题!
我的sql语句是:UPDATE personal SET user_name ='孙浩6',family_id = '00000203',generation = '2',ranking = '26',PASSWORD = '' permission = '9' WHERE id = '11' LIMIT 1
错误代码: 1064
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
------解决思路----------------------
permission 前面少了个逗号也看不出来吗?
错误信息已经明确的告诉你在解析到 'permission = '9' where id = '11' limit 1' 时出现了问题!
相关文章
相关视频
- 详解win10下PHP的安装配置(以php5.6为...
- php Swoole实现毫秒定时计划任务(详解)
- 【DTM】PHP协程客户端v0.1 beta版本发...
- PHP中类的理解和应用[一]_PHP教程
- 在用SQLyog执行sql语句时报错!求大神帮忙看...
上一篇: 举例讲解PHP面对对象编程的多态_PHP
下一篇: PHP代码优化之缓存(转)