大家好,请问下载你的农场后,在导入以下三个SQL数据库文件的时候出错,是什么原因呢?
2.到phpmyadmin导入
uchome_happyfarm_config.sql
uchome_happyfarm_mc.sql
uchome_happyfarm_nc.sql
出错界面:(选其中一个文件错误,三个都是一样错)
SQL 查询 :
CREATE TABLE `uchome_happyfarm_config` (
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`uid` int( 11 ) NOT NULL DEFAULT '0',
`money` int( 11 ) DEFAULT '0',
`YB` int( 11 ) DEFAULT '0',
`JB` int( 11 ) DEFAULT '0',
`Message` text NOT NULL ,
`setting1` text CHARACTER SET utf8 NOT NULL ,
`setting2` text CHARACTER SET utf8 NOT NULL ,
`setting3` text CHARACTER SET utf8 NOT NULL ,
`setting4` text CHARACTER SET utf8 NOT NULL ,
`setting5` text CHARACTER SET utf8 NOT NULL ,
`setting6` text CHARACTER SET utf8 NOT NULL ,
`pf` int( 11 ) DEFAULT '0',
`vip` int( 11 ) DEFAULT '1',
PRIMARY KEY ( `id` )
)ENGINE = InnoDB DEFAULTCHARSET = latin1
MySQL 返回:
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,
`setting2` text CHARACTER SET u
请问是什么原因呢?谢谢!! |