代码错误求解 提示在`isHot` tinynt(1) default 0附近

Question

DROP TABLE IF EXISTS `web_shop`;

CREATE TABLE `web_shop`(

`id` int unsigned auto_increment key,

`pName` varchar(50) not null unique,

`pSn` varchar(50) not null,

`pNum` int unsigned default 1,

`pPrice` decimal(10,2) not null,

`pDesc` text,

`pImg` varchar(50) not null,

`pubTime` int unsigned not null,

`isHot` tinynt(1) default 0,

`cId` smallint unsigned not null,

`pCommen` text,

`pSold` char(7),

`pBrand` char(20) not null

);

Answer 1

DROP TABLE IF EXISTS `web_shop`; CREATE TABLE `web_shop`( `id` int unsigned auto_increment key, `pName` varchar(50) not null unique, `pSn` varchar(50) not null, `pNum` int unsigned default 1, `pPrice` decimal(10,2) not null, `pDesc` text, `pImg` varchar(50) not null, `pubTime` int unsigned not null, `isHot` tinyint(1) default 0, `cId` smallint unsigned not null, `pCommen` text, `pSold` char(7), `pBrand` char(20) not null );复制这个

Answer 2

tinyint

Answer 3

tinynt，错了。正确的是：tinyint