插入mysql语句报错：1064 - You have an error in your SQL syntax; check the manual that corresponds to your M...

最新推荐文章于 2024-08-16 16:30:26 发布

weixin_30388677

最新推荐文章于 2024-08-16 16:30:26 发布

阅读量328

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/thinkingandworkinghard/p/6999113.html

版权

插入一个很简单的sql语句时候，mysql一直报错：

[SQL] INSERT INTO ORDER (
id,
activity_id,
order_type,
phone,
order_amount,
order_state,
pay_type
)
VALUES
(
'4',
'2121313',
'1',
'13552444989',
'1',
'1',
'1'
)

[Err] 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 (
id,
activity_id,
order_type,
phone,
order_amount,
order_stat' at line 1

想了半天，忽然发现 order是mysql的关键字，不能当做表名字来使用。。。真是醉了！

转载于:https://www.cnblogs.com/thinkingandworkinghard/p/6999113.html