【异常】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`

  

posted @ 2020-06-01 07:22  Questions张  阅读(2263)  评论(0编辑  收藏  举报