代码与廖老师的一致,sql如下:
CREATE TABLE `user` (
`id` varchar(20) NOT NULL,
`name` varchar(20) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `book` (
`user_id` varchar(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `fk_user` (`user_id`),
CONSTRAINT `fk_user` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
当我正常运行的时候,一直都提示Ensure that referencing columns are associated with a ForeignKey or ForeignKey,
在数据库中是建立了外键的,不知道哪里出问题了,麻烦大家帮我解答。非常感谢
Sign in to make a reply
想抱大腿的茜弟
代码与廖老师的一致,sql如下:
CREATE TABLE `user` (
`id` varchar(20) NOT NULL,
`name` varchar(20) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `book` (
`id` varchar(20) NOT NULL,
`name` varchar(20) DEFAULT NULL,
`user_id` varchar(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `fk_user` (`user_id`),
CONSTRAINT `fk_user` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
当我正常运行的时候,一直都提示Ensure that referencing columns are associated with a ForeignKey or ForeignKey,
在数据库中是建立了外键的,不知道哪里出问题了,麻烦大家帮我解答。非常感谢