数据库demo
-- Table "user" DDLCREATE TABLE `user` (
`id` int(11) NOT NULL auto_increment,
`userName` varchar(10) NOT NULL,
`passWord` varchar(10) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `userName` (`userName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- Table "book" DDLCREATE TABLE `book` (
`id` int(11) NOT NULL auto_increment,
`bookName` varchar(255) NOT NULL,
`user` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `user` (`user`),
CONSTRAINT `book_ibfk_1` FOREIGN KEY (`user`) Ruser表建立成功 book有错误 最后的 (`user`) R R什么意思是错误还是?
-- Table "user" DDLCREATE TABLE `user` (
`id` int(11) NOT NULL auto_increment,
`userName` varchar(10) NOT NULL,
`passWord` varchar(10) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `userName` (`userName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- Table "book" DDLCREATE TABLE `book` (
`id` int(11) NOT NULL auto_increment,
`bookName` varchar(255) NOT NULL,
`user` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `user` (`user`),
CONSTRAINT `book_ibfk_1` FOREIGN KEY (`user`) Ruser表建立成功 book有错误 最后的 (`user`) R R什么意思是错误还是?
REFERENCES tbl_name [(index_col_name,...)]
[MATCH FULL | MATCH PARTIAL | MATCH SIMPLE]
[ON DELETE reference_option]
[ON UPDATE reference_option]
CREATE TABLE `book` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`bookName` VARCHAR(255) NOT NULL,
`user` INT(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `user` (`user`),
CONSTRAINT `book_ibfk_1` FOREIGN KEY (`user`) REFERENCES `book`(ID)) ENGINE=INNODB DEFAULT CHARSET=utf8