MySQL查询错误,并带有名为"order"的表 [英] MySQL query error with a table named "order"
本文介绍了MySQL查询错误,并带有名为"order"的表的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我遇到了这个问题,但我只是找到了解决方案,所以无论如何如果有人偶然发现它,我都会在这里写下. 这是我的mysql查询:
I have this problem but I just found out the solution so I'll write it here anyway in case anyone stumbles in it. This is my mysql query:
mysql_query("SELECT id FROM order ORDER BY id DESC LIMIT 1")
我收到的错误是
您的SQL语法有错误;检查与您的MySQL服务器版本相对应的手册以获取正确的语法,以在第1行的"order ORDER BY id DESC 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 'order ORDER BY id DESC LIMIT 1' at line 1
推荐答案
订单是保留的Word.您必须在回车符中使用将ORDER括起来".
Order is reserved Word. You have to use like Enclose ORDER in back-ticks.
尝试一下
mysql_query("SELECT id FROM `order` ORDER BY id DESC LIMIT 1")
Reserved Words
这篇关于MySQL查询错误,并带有名为"order"的表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文