导入数据出现以下错误:
SQL 查询:
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, `farm_log` text character[...]
MySQL 返回:
#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 'character set utf8 NOT NULL,
`animal` text character set utf |