数据库建表

mysql> create table order(

    -> oid varchar(20) primary key,

    ->     uid varchar(20),

    -> gid varchar(20),

    -> orderdate datetime,

    -> status varchar(20),

    -> foreign key(uid) references user(user.uid),

    -> foreign key(gid) references goods(goods.gid)

    -> );

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(

oid varchar(20) primary key,

    uid varchar(20),

gid varchar(20),

orderd' at line 1

gid 和uid 为另外2表主键