create table LeavingMessage
(messageID int auto_increment,
goodsID varchar(10),
customerName varchar(20),
leavingTime datetime,
messageContent varchar(200)
primary key (messageID),
foreign key (goodsID) references Goods
)
提示我 Can't create table 'shoppingdb.leavingmessage' (errno: 150)
这是神马情况?
(messageID int auto_increment,
goodsID varchar(10),
customerName varchar(20),
leavingTime datetime,
messageContent varchar(200)
primary key (messageID),
foreign key (goodsID) references Goods
)
提示我 Can't create table 'shoppingdb.leavingmessage' (errno: 150)
这是神马情况?
估计是错在这里。
先把这个去掉再试试。
然后检查一下goodsID和参照表Goods中的对应字段是不是严格一致。
foreign key(goodsID) references Goods
这句后面应该有逗号吧