Question

数据库导入问题phpmyadmin

CREATE TABLE `action` (

`id` int( 2 ) unsigned NOT NULL AUTO_INCREMENT ,
`fenlei` varchar( 20 ) NOT NULL ,
`content` longtext NOT NULL ,
`cid` int( 20 ) NOT NULL ,
`time` date NOT NULL ,
PRIMARY KEY ( `id` ) ,
KEY `cid` ( `cid` )
) ENGINE = MYISAM DEFAULT CHARSET = 'gb2312' AUTO_INCREMENT = '21';

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='gb2312' AUTO_INCREMENT='21'' at line 9

#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='gb2312' AUTO_INCREMENT='21'' at line 9
-
-- 表的结构 `action`
--

CREATE TABLE `action` (
`id` int(2) unsigned NOT NULL AUTO_INCREMENT,
`fenlei`

varchar(20) NOT NULL,
`content` longtext NOT NULL,
`cid` int(20) NOT NULL,
`time` date NOT NULL,
PRIMARY KEY (`id`),
KEY `cid`(`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=21;
有语法错误吗

Answer 1

AUTO_INCREMENT = '21'去了试一下