KEY `FK_order_1` (`bookid`),
KEY `FK_order_2` (`userid`),
CONSTRAINT `FK_order_1` FOREIGN KEY (`bookid`) REFERENCES `bookinfo` (`id`),
CONSTRAINT `FK_order_2` FOREIGN KEY (`userid`) REFERENCES `userinfo` (`id`),
上面为外键约束部分,求大神讲解下那几个引号应该用什么标号?(求讲解详细点)还有就是这个建表代码对不对!!!急救阿!毕业设计要交了!感恩不尽!
KEY `FK_order_2` (`userid`),
CONSTRAINT `FK_order_1` FOREIGN KEY (`bookid`) REFERENCES `bookinfo` (`id`),
CONSTRAINT `FK_order_2` FOREIGN KEY (`userid`) REFERENCES `userinfo` (`id`),
上面为外键约束部分,求大神讲解下那几个引号应该用什么标号?(求讲解详细点)还有就是这个建表代码对不对!!!急救阿!毕业设计要交了!感恩不尽!
KEY 'FK_order_1' ('bookid'),
KEY 'FK_order_2' ('userid'),
CONSTRAINT 'FK_order_1' FOREIGN KEY ('bookid') REFERENCES 'bookinfo' ('id'),
CONSTRAINT 'FK_order_2' FOREIGN KEY ('userid') REFERENCES 'userinfo' ('id')--试一下这样
然后在右键表->编写脚本到->create到->新建查询窗口,显示建表代码
不知道在mysql中是否能用