问题描述:
在进行mysql进行查询时,很简单的一个查询语句,但就是查询不出来,报如下错误:
SELECT * FROM ORDER WHERE order_no='5000001805592631';
错误代码: 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 'ORDER
WHERE order_no='5000001805592631' LIMIT 0, 1000' at line 2
原因分析:
仔细排查了一下,发现是我的表名和mysql里的关键字进行冲突了
解决方案:
对你要查询的表名加上反引号:``
SELECT * FROM `ORDER` WHERE order_no='5000001805592631';