Mysql 执行升级语句出错

来源：百度知道 编辑：UC知道 时间：2024/09/25 11:32:07
DROP TABLE IF EXISTS `bbs_vip_members`;
CREATE TABLE `bbs_vip_members` (
`uid` mediumint(8) unsigned NOT NULL auto_increment,
`username` char(15) default '',
`groupid` smallint(6) default '0',
`vip` int(10) default '0',
`level` int(10) default '0',
`exp` int(10) default '0',
`tiem` int(10) default '0',
PRIMARY KEY (`uid`),
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=gbk;
DROP TABLE IF EXISTS `cdb_vipsetting`;
CREATE TABLE `cdb_vipsetting` (
`level` int(10) NOT NULL auto_increment,
`name` char(10) default 0,
`v1` mediumint(2) default 0,
`v2` mediumint(2) default 0,
`v3` mediumint(2) default 0,
`v4` mediumint(2) default 0,
`v5` mediumint(2) default 0,
`v6` mediumint(2) default 0,
PRIMARY KEY (`level`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=gbk;
INSERT INTO `cdb_vipsetting` VAL

把PRIMARY KEY (`uid`),
后面的,号去掉

那么就是这样：

DROP TABLE IF EXISTS `bbs_vip_members`;
CREATE TABLE `bbs_vip_members` (
`uid` mediumint(8) unsigned NOT NULL auto_increment,
`username` char(15) default '',
`groupid` smallint(6) default '0',
`vip` int(10) default '0',
`level` int(10) default '0',
`exp` int(10) default '0',
`tiem` int(10) default '0',
PRIMARY KEY (`uid`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=gbk;
DROP TABLE IF EXISTS `cdb_vipsetting`;
CREATE TABLE `cdb_vipsetting` (
`level` int(10) NOT NULL auto_increment,
`name` char(10) default 0,
`v1` mediumint(2) default 0,
`v2` mediumint(2) default 0,
`v3` mediumint(2) default 0,
`v4` mediumint(2) default 0,
`v5` mediumint(2) default 0,
`v6` mediumint(2) default 0,
PRIMARY KEY (`level`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAU