Question

MYSQL ----出现 ERROR 1064 You have an error in your SQL syntax;

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 ') ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=gbk' at line 8
语句：
CREATE TABLE `uchome_car_favi` (
`id` mediumint(11) NOT NULL AUTO_INCREMENT,
`carid` mediumint(11) NOT NULL DEFAULT '0',
`uid` mediumint(11) NOT NULL,
`username` char(20) NOT NULL DEFAULT '0',
`dateline` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=gbk;

Answer 1

改成CREATE TABLE `uchome_car_favi` (
`id` mediumint(11) NOT NULL AUTO_INCREMENT,
`carid` mediumint(11) NOT NULL DEFAULT '0',
`uid` mediumint(11) NOT NULL,
`username` char(20) NOT NULL DEFAULT '0',
`dateline` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=gbk;
原因是PRIMARY KEY (`id`)后面多了个“，”

Answer 2

CREATE TABLE `uchome_car_favi` (
`id` mediumint(11) NOT NULL AUTO_INCREMENT,
`carid` mediumint(11) NOT NULL DEFAULT '0',
`uid` mediumint(11) NOT NULL,
`username` char(20) NOT NULL DEFAULT '0',
`dateline` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=gbk;

最后的ID多了一个,符号.

错误提示是语法错误

Answer 3

GYDSFUIFUIYBGYISDF

追问

能不能讲清楚点啊 有急用