DROP TABLE IF EXISTS `kc`;
CREATE TABLE `kc` (
`ID` int(11) NOT NULL AUTO_INCREMENT ,
`CategoryID` int(11) NULL DEFAULT NULL ,
`VarietiesID` int(11) NULL DEFAULT NULL ,
`Type` varchar(50) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL ,
`ColorID` int(11) NULL DEFAULT NULL ,
`LayerID` int(11) NULL DEFAULT NULL ,
`ThicknessID` int(11) NULL DEFAULT NULL ,
`Specification` varchar(50) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL ,
`Meter` varchar(50) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL ,
`Square` varchar(50) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL ,
`Data` varchar(50) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL ,
`Number` int(11) NULL DEFAULT NULL ,
`Remark` varchar(50) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL ,
`Nmb` int(10) NULL DEFAULT NULL ,
PRIMARY KEY (`ID`),
FOREIGN KEY (`CategoryID`) REFERENCES `category` (`CategoryID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
FOREIGN KEY (`ColorID`) REFERENCES `color` (`ColorID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
FOREIGN KEY (`LayerID`) REFERENCES `layer` (`LayerID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
FOREIGN KEY (`ThicknessID`) REFERENCES `thickness` (`ThicknessID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
FOREIGN KEY (`VarietiesID`) REFERENCES `varieties` (`VarietiesID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
INDEX `CategoryID` (`CategoryID`) USING BTREE ,
INDEX `ColorID` (`ColorID`) USING BTREE ,
INDEX `LayerID` (`LayerID`) USING BTREE ,
INDEX `VarietiesID` (`VarietiesID`) USING BTREE ,
INDEX `Thickness` (`ThicknessID`) USING BTREE
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=gbk COLLATE=gbk_chinese_ci
COMMENT='InnoDB free: 3072 kB; (`CategoryID`) REFER `armstrong/category`(`CategoryID`) ON'
AUTO_INCREMENT=3
;
我所有表都插进去了,就剩下KC这个表了.插这个表的时候报错
报错是:
MySQL 返回:
#1105 - Too long comment for table 'kc'
嘛意思?怎么改?
1 个解决方案
#1
最好的办法升级你的mysql,你用的应该是5.0
如果不升级,减少你的表最后的comment字段的长度