ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your
来源:互联网 发布:fw是什么软件 编辑:程序博客网 时间:2024/06/06 20:39
错误信息:
UPDATE Role SET Desc = '管理员' WHERE Id = 11;ERROR 1064 (42000): 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 'Desc = '管理员' at line 1
原因:
desc是排序关键词,要加引号或加反引号(`)
在建表的时候切记,不要用关键词做字段名
阅读全文
0 0
- ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your
- ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your
- ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your
- ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your
- ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your
- ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your
- ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your
- ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your
- ERROR 1064 (42000):You have an error in your SQL syntax; check the manual that corresponds to your M
- ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your
- ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your
- Error Code : 1064 You have an error in your SQL syntax; check the manual that corresponds to your My
- 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server
- [Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL s
- [Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL s
- Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL se
- [Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds...
- ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server
- Jenkins集成TestNG Junit自动化测试
- 一张表中两个字段互相关联
- jmeter企业内训简报
- square开源日历控件—CalendarPickerView源码导读
- ArrayList与LinkedList的普通for循环遍历效率对比
- ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your
- css强制换行和超出隐藏实现
- 马云自动收银系统淘咖啡店系统开发
- qt中的toUtf8, toLatin1, Local8bit, toUcs4
- UIWebView在修改字体大小出现闪烁及取消放缩效果
- USBASP烧录出现的几种错误
- HTTP 协议
- VideoView播放视频
- LINUX内核进程调度学习笔记(一)