问个问题:建表的时候出现如下错误
数据库连接出错:CREATE TABLE `uchome_plug_newfarm` ( `uid` mediumint(8) NOT NULL, `farmlandstatus` text character set utf8 NOT NULL, `animal` text character set utf8 NOT NULL, `taskid` int(2) NOT NULL default '1', `charm` int(10) NOT NULL default '0', `money` int(10) NOT NULL default '0', `exp` int(10) NOT NULL default '0', `mc_exp` int(10) NOT NULL default '0', `fb` int(10) NOT NULL default '0', `reclaim` smallint(2) NOT NULL default '6', `package` text character set utf8 NOT NULL, `mc_package` text character set utf8 NOT NULL, `fertilizer` text character set utf8 NOT NULL, `decorative` text character set utf8 NOT NULL, `fruit` text character set utf8 NOT NULL, `dog` text character set utf8 NOT NULL, `nosegay` text character set utf8 NOT NULL, `message` text character set utf8 NOT NULL, `mc_taskid` int(2) NOT NULL default '0', `mc_taskid1` int(2) NOT NULL default '0', `mc_log` text character set utf8 NOT NULL, PRIMARY KEY (`uid`)) TYPE=MyISAM ;
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 'character set utf8 NOT NULL, `animal` text character set utf8
1064
是哪里出问题了 |