mysql创建表为什么第二次_Mysql创建第一个表成功创建第二个表时出错

mysql>usebuy;Databasechangedmysql>createtableuser(->idint(11)notnull,->namevarchar(20)defaultnull,->passwordvarchar(10)defaultnull,->coinint(11)defaultnull,->consumeint(1...

mysql> use buy;

Database changed

mysql> create table user(

-> id int(11) not null,

-> name varchar(20)default null,

-> password varchar(10)default null,

-> coin int(11)default null,

-> consume int(11)default null,

-> type varchar(5)default null,

-> primary key(id)

-> );

Query OK, 0 rows affected (0.02 sec)

mysql> create table order(

-> orderid int(11) not null,

-> type varchar(10)default null,

-> price int(11)default null,

-> datetime datetime fefault null,

-> userid int(11)default null,

-> productname narchar(20)default null,

-> primary key(orderid)

-> );

ERROR 1064 (42000): 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

(

orderid int(11) not null,

type varchar(10)default null,

price int(11)defa' at line 1

第二为什么会错误怎么改？

展开