插入mysql语句报错：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

插入一个很简单的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的关键字，不能当做表名字来使用。。。 真是醉了！