数据库我不太懂求大神帮忙啊SETFOREIGN_KEY_CHECKS=0;DROPTABLEIFEXISTS`tb_bookcase`;CREATETABLE`tb_bookcase`(`id`int(10)unsignedNOTNULLAUTO_INCREMENT,`name`varchar(30)DEFAUL...
数据库我不太懂 求大神帮忙啊
SET FOREIGN_KEY_CHECKS=0;
DROP TABLE IF EXISTS `tb_bookcase`;
CREATE TABLE `tb_bookcase` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(30) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=gbk;
INSERT INTO `tb_bookcase` VALUES ('4', '宸-1');
INSERT INTO `tb_bookcase` VALUES ('5', '宸-2');
INSERT INTO `tb_bookcase` VALUES ('6', '鍙矨-1');
INSERT INTO `tb_bookcase` VALUES ('8', '鍙矨-2');
DROP TABLE IF EXISTS `tb_bookinfo`;