SQL导入数据库提示错误，麻烦楼主说个解决办法，谢谢！
错误
SQL 查询 :
CREATE TABLE `uchome_happyfarm_nc` (
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`uid` int( 11 ) NOT NULL DEFAULT '0',
`Status` text NOT NULL ,
`reclaim` int( 11 ) NOT NULL DEFAULT '6',
`exp` int( 11 ) NOT NULL DEFAULT '0',
`taskid` int( 11 ) NOT NULL DEFAULT '0',
`package` text,
`fruit` text,
`tools` text,
`decorative` text,
`dog` text,
`Weed` text,
`pest` text,
`water` text,
`badnum` int( 11 ) NOT NULL DEFAULT '50',
`activeItem` int( 11 ) NOT NULL DEFAULT '90001',
`repertory` text NOT NULL ,
`log` text NOT NULL ,
`healthmode` int( 2 ) NOT NULL DEFAULT '0',
`valid` int( 1 ) NOT NULL DEFAULT '0',
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 'DEFAULT CHARSET=latin1' at line 23 |
[复制链接]
显身卡