导入第一个数据库怎么出现如下错误啊,俺不懂,请高手帮个忙
错误
SQL 查询:
CREATE TABLE `uchome_plug_newfarm` (
`uid` mediumint( 8 ) unsigned NOT NULL default '0', `username` varchar( 20 ) NOT NULL , `farmlandstatus` text NOT NULL , `animal` text NOT NULL , `taskid` int( 2 ) NOT NULL default '1', `charm` int( 10 ) NOT NULL default '0', `money` int( 10 ) NOT NULL default '0', `fb` int( 10 ) NOT NULL default '0', `exp` int( 10 ) NOT NULL default '0', `mc_exp` int( 10 ) NOT NULL default '0', `reclaim` smallint( 2 ) NOT NULL default '6', `package` text NOT NULL , `mc_package` text NOT NULL , `fertilizer` text NOT NULL , `decorative` text NOT NULL , `fruit` text NOT NULL , `dog` text NOT NULL , `nosegay` text NOT NULL , `message` text NOT NULL , `mc_taskid` int( 2 ) NOT NULL default '0', `wenzi` text NOT NULL , `bad` int( 10 ) NOT NULL default '0', `mc_chat` text NOT NULL , `repertory` text NOT NULL , `parade` text NOT NULL , `dabian` tinyint( 3 ) NOT NULL default '0', `badtime` int( 11 ) NOT NULL default '0', `sfeedleft` int( 10 ) NOT NULL default '0', `levelup` int( 10 ) NOT NULL default '200', PRIMARY KEY ( `uid` ) ) ENGINE = MYISAM DEFAULT CHARSET = gbk;
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 'CREATE TABLE `uchome_plug_newfarm` (
`uid` mediumint(8) unsigned NOT NULL ' at line 1 |