MySQL错误：ERROR 1064 (42000): use near 'order’解决
- WBOYOriginal
- 2016-06-07 15:18:141634browse
环境 MySQL Sever 5.1 MySQL命令行工具 问题 ERROR 1064 (42000): You have an error inyour SQL syntax; check the manual that orresponds to your MySQL server versionfor the right syntax to use near 'order’ 解决 表名使用了关键字，数据库中命名要
环境
MySQL Sever 5.1 + MySQL命令行工具
问题
ERROR 1064 (42000): You have an error inyour SQL syntax; check the manual that orresponds to your MySQL server versionfor the right syntax to use near 'order’
解决
表名使用了关键字，数据库中命名要避免使用关键字。Hibernate中查询语句为字段起别名，目的就是避免使用关键字。
参考资料
http://hi.baidu.com/yuiezt/item/fb563d6b4445b3156995e668
http://www.examw.com/biancheng/mysql/165562/
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：在RHEL AS 3 上安装Oracle10g 参考手册(1)Next article：MySQL命令行创建用户与授权