MySQL Error
Message: MySQL Query Error
SQL: CREATE TABLE IF NOT EXISTS uchome_award_info ( `id` int(4) unsigned NOT NULL auto_increment, `awardno` varchar(16) collate gbk_bin NOT NULL COMMENT '奖品编号', `awardname` varchar(20) collate gbk_bin NOT NULL COMMENT '奖品名称', `credit` int(4) NOT NULL COMMENT '所需积分', `remain` smallint(6) unsigned default '0' COMMENT '剩余数量', `exchange` smallint(6) unsigned default '0' COMMENT '已兑换数量', `isopen` tinyint(1) NOT NULL COMMENT '开启标志 1:可以兑换 0:不可以', `awardimg` varchar(255) collate gbk_bin NOT NULL COMMENT '奖品图片', `description` text collate gbk_bin NOT NULL COMMENT '奖品简介', `orders` int(4) default NULL COMMENT '排序', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk COLLATE=gbk_bin COMMENT='奖品分类信息表';
Error: 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 'collate gbk_bin NOT NULL COMMENT '奖品编号', `awardname` var
Errno.: 1064 怎么会这样??? |