标题: 求助mysql5.5出错#1067 - Invalid default value for 'Hot' [打印本页] 作者: a751116023 时间: 2014-7-4 10:30 标题: 求助mysql5.5出错#1067 - Invalid default value for 'Hot' create table article(ArticleID int(10) not null auto_increment,ChannelID int(5) not null,ClassId int(5) not null,SpecialId int(5),Title varchar(255) not null,TitleAll varchar(255),TitleIntact varchar(255),Subheading varchar(255),Author varchar(20) ,CopyFrom varchar(255),Inputer varchar(15) ,LinkUrl varchar(255),Ediror varchar(15),Keyword varchar(100) not null,Hits int(8) default 0,UpdateTime varchar(30) not null,Hot bit default '0',OnTop bit default '0',Elite bit default '0',Passed bit default '0',Content text not null,IncludePic int(1),DefaultPicUrl varchar(255),UploadFiles varchar(255),ReadPoint int(5),PaginationType int(3) ,Deleted bit default '0',SkinId int(3),TemplateId int(3), Stars int(3),TitleFontColor varchar(100),TitleFontType int(3),MaxCharPerPage int(7),ShowCommentLink bit default '0',Receive bit default '0',ReceiveUser varchar(15),Received varchar(15),AutoReceiveTime int (3),ReceiveType int(3), Intro text not null,PRIMARY KEY(ArticleID));