错误
SQL 查询:
CREATE TABLE IF NOT EXISTS `cdb_toxy_ground` (
`uid` mediumint( 8 ) unsigned NOT NULL DEFAULT '0',
`regdate` date NOT NULL DEFAULT '0000-00-00',
`ex` int( 10 ) NOT NULL DEFAULT '0',
`bedate` date NOT NULL DEFAULT '0000-00-00',
`beg` smallint( 6 ) NOT NULL DEFAULT '0',
`beb` smallint( 6 ) NOT NULL DEFAULT '0',
`date` date NOT NULL DEFAULT '0000-00-00',
`grass` smallint( 6 ) NOT NULL DEFAULT '0',
`bug` smallint( 6 ) NOT NULL DEFAULT '0',
`background` char( 10 ) NOT NULL DEFAULT 'bg1',
`d1` char( 10 ) NOT NULL DEFAULT 'lvdi',
`p1` smallint( 6 ) NOT NULL DEFAULT '0',
`pt1` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`pn1` smallint( 6 ) NOT NULL DEFAULT '0',
`g1` smallint( 1 ) NOT NULL DEFAULT '0',
`b1` smallint( 1 ) NOT NULL DEFAULT '0',
PRIMARY KEY ( `uid` ) ,
UNIQUE KEY `username` ( `regdate` ) ,
KEY `groupid` ( `bug` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8;
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 'DEFAULT CHARSET=utf8' at line 21 |