110# 恋之Q宠家族
照做了,但是:- 错误
- 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 SET utf8 NOT NULL ,
- `wenzi` text CHARACTER SET utf8 NOT NULL ,
- `bad` int( 10 ) NOT NULL default '0',
- `mc_chat` text CHARACTER SET utf8 NOT NULL ,
- `log` text CHARACTER SET utf8 NOT NULL ,
- 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 'character set utf8 NOT NULL,
- `animal` text character set utf
复制代码 |