【异常】MySQL建表报错: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"' at line 1

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"' at line 1

  

2 因为order是关键字,加上单引号`建表就可以了

drop table if exists `order`;
create table `order`

  

原文地址:https://www.cnblogs.com/QuestionsZhang/p/13023143.html