刚刚学不久。。。
CREATE TABLE `Info`(
`GoodsID` varchar(50) NOT NULL,
`ClassID` varchar(50) NOT NULL,
`GoodsIntroduce` Text(250) NULL,
`GoodsBrand` varchar(50) NULL,
`GoodsUnit` varchar(50) NULL,
`GoodsUrl` varchar(50) NULL,
`GoodsPrice` float(50)) NULL,
`Isrefinement` bool(1) default 1,
`IsHot` bool(1) default 1,
`IsShow` bool(1) default 0,
`AddDate` datetime(32) NULL,
`IsDisCount` bool(1) default 0,
PRIMARY KEY (`GoodsID`),
FOREIGN KEY(`ClassID`)
)ENGINE=INNODB;
//#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL,
`Isrefinement` bool(1) default 1,
`IsHot` bool(1) default 1,
' at line 8
CREATE TABLE `Info`(
`GoodsID` varchar(50) NOT NULL,
`ClassID` varchar(50) NOT NULL,
`GoodsIntroduce` Text(250) NULL,
`GoodsBrand` varchar(50) NULL,
`GoodsUnit` varchar(50) NULL,
`GoodsUrl` varchar(50) NULL,
`GoodsPrice` float(50)) NULL,
`Isrefinement` bool(1) default 1,
`IsHot` bool(1) default 1,
`IsShow` bool(1) default 0,
`AddDate` datetime(32) NULL,
`IsDisCount` bool(1) default 0,
PRIMARY KEY (`GoodsID`),
FOREIGN KEY(`ClassID`)
)ENGINE=INNODB;
//#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL,
`Isrefinement` bool(1) default 1,
`IsHot` bool(1) default 1,
' at line 8
