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 (U_ID,PRICE) values(1073,199.34)’ at line 1
错误代码
insert into order (U_ID,PRICE) values(1073,199.34);
order作为关键字无法不能作为表名来使用,如果使用可以使用 ‘order’ 操作。
为避免此类错误,切记不要使用关键字做表名