mysql 建表无论怎么建表都是1064错误，求大神解答--

Question

mysql> create table order(
    -> id varchar(20)
    -> );
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 varchar(20)

)' at line 1

Answer 1

order是关键字，哪种语言都不允许用关键字定义变量和类吧。order这种含义清晰的词应该还是能看出来的，基础不扎实啊。
具体参考这个网站MySQL关键字及保留字