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 '

mysql中如果字段使用了关键字,在插入和更新时会提示

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

常见的关键字有 desc,asc ...,可以在字段名前后加上`  如  `desc` 
上一篇:MySQL遇到check the manual that corresponds to your MySQL server version for the right syntax错误


下一篇:JSP网站开发基础总结《十四》