Suifeng： 那就先执行 DROP TABLE IF EXISTS `qb_vote_liwu`; 再执行下面的代码 提醒你执行了上面 你自己添加的礼物就清空了 删除 Suifeng： CREATE TABLE IF NOT EXISTS `qb_vote_liwu` ( `id` mediumint(6) NOT NULL AUTO_INCREMENT, `uid` mediumint(7) NOT NULL COMMENT '创建者的uid', `aid` mediumint(7) NOT NULL COMMENT '投票项目的ID', `vote_num` mediumint(7) NOT NULL COMMENT '增加票数', `title` varchar(150) NOT NULL COMMENT '礼物名称', `about` text NOT NULL COMMENT '礼物详细介绍', `price` decimal(6,2) NOT NULL DEFAULT '0.00' COMMENT '需要消费RMB', `jifen` mediumint(5) NOT NULL COMMENT '消费积分个数', `picurl` varchar(150) NOT NULL COMMENT '缩略图', `type` tinyint(4) NOT NULL COMMENT '礼物类型,2 为静态图片格式 1 为svga格式 0为GIF格式', `svga` varchar(150) NOT NULL COMMENT '动画源文件', `swftime` smallint(5) NOT NULL COMMENT 'GIF动画时间长度(秒)', `list` int(10) NOT NULL COMMENT '排序值', PRIMARY KEY (`id`), KEY `price` (`price`), KEY `uid` (`uid`), KEY `aid` (`aid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='圈子群聊礼物' AUTO_INCREMENT=63 ; 执行这两部成功，然后导入礼物表，一个一个执行成功，多个一起不行，导入不了，不过一个一个浪费点时间，总归可以导入了，谢谢随风大侠，指导，又学会一项功能，感谢哈，

[10501] PDOException in Connection.php line 456 SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '4' for key 'PRIMARY' // 调试结束 $this->debug(false); $this->numRows = $this->PDOStatement->rowCount(); return $this->numRows; } catch (\PDOException $e) { if ($this->isBreak($e)) { return $this->close()->execute($sql, $bind); } throw new PDOException($e, $this->config, $this->getLastsql()); 提交后这样，数据库坏了

Suifeng 1小时前 0 回复 INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(4, 0, 0, 0, '梅花三弄', '', '0.10', 10, 'https://svn.php168.com/small/svga_small/1.gif', 1, 'https://svn.php168.com/svga/1.svga', 0, 0);

执行了，不过提交后数据库乱码了，

INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(4, 0, 0, 0, '梅花三弄', '', '0.10', 10, 'https://svn.php168.com/small/svga_small/1.gif', 1, 'https://svn.php168.com/svga/1.svga', 0, 0); INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(5, 0, 0, 0, '666大顺', '', '0.60', 60, 'https://svn.php168.com/small/svga_small/2.gif', 1, 'https://svn.php168.com/svga/2.svga', 0, 0); INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(6, 0, 0, 0, '豪华游艇', '', '0.50', 50, 'https://svn.php168.com/small/svga_small/3.gif', 1, 'https://svn.php168.com/svga/3.svga', 0, 8); INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(7, 0, 0, 0, '情侣难舍难分', '', '0.10', 10, 'https://svn.php168.com/small/svga_small/4.gif', 1, 'https://svn.php168.com/svga/4.svga', 0, 0); INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(8, 0, 0, 0, '火箭', '', '2.00', 200, 'https://svn.php168.com/small/svga_small/5.gif', 1, 'https://svn.php168.com/svga/5.svga', 0, 6); INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(9, 0, 0, 0, '泡妞神器(跑车)', '', '3.00', 300, 'https://svn.php168.com/small/svga_small/6.gif', 1, 'https://svn.php168.com/svga/6.svga', 0, 7); INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(10, 0, 0, 0, '超级跑车', '', '3000.00', 300, 'https://svn.php168.com/small/svga_small/7.gif', 1, 'https://svn.php168.com/svga/7.svga', 0, 10); INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(11, 0, 0, 0, '满天烟花', '', '0.10', 10, 'https://svn.php168.com/small/svga_small/8.gif', 1, 'https://svn.php168.com/svga/8.svga', 0, 0); INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(12, 0, 0, 0, '女神', '', '0.10', 10, 'https://svn.php168.com/small/svga_small/9.gif', 1, 'https://svn.php168.com/svga/9.svga', 0, 0); INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(13, 0, 0, 0, '飞船', '', '0.10', 10, 'https://svn.php168.com/small/svga_small/10.gif', 1, 'https://svn.php168.com/svga/10.svga', 0, 0); INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(14, 0, 0, 0, '轻汽球', '', '0.10', 10, 'https://svn.php168.com/small/svga_small/11.gif', 1, 'https://svn.php168.com/svga/11.svga', 0, 0); INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(15, 0, 0, 0, '童话世界', '', '0.10', 10, 'https://svn.php168.com/small/svga_small/12.gif', 1, 'https://svn.php168.com/svga/12.svga', 0, 0); INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(16, 0, 0, 0, '情侣', '', '0.10', 10, 'https://svn.php168.com/small/svga_small/13.gif', 1, 'https://svn.php168.com/svga/13.svga', 0, 0); INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(17, 0, 0, 0, '爱的世界', '', '0.10', 10, 'https://svn.php168.com/small/svga_small/14.gif', 1, 'https://svn.php168.com/svga/14.svga', 0, 0); INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(18, 0, 0, 0, '两人世界', '', '0.10', 10, 'https://svn.php168.com/small/svga_small/15.gif', 1, 'https://svn.php168.com/svga/15.svga', 0, 0); INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(19, 0, 0, 0, '爱心盒', '', '0.10', 10, 'https://svn.php168.com/small/svga_small/16.gif', 1, 'https://svn.php168.com/svga/16.svga', 0, 0); INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(20, 0, 0, 0, '城堡', '', '0.10', 10, 'https://svn.php168.com/small/svga_small/17.gif', 1, 'https://svn.php168.com/svga/17.svga', 0, 0); INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(21, 0, 0, 0, '轻汽球', '', '0.10', 10, 'https://svn.php168.com/small/svga_small/18.gif', 1, 'https://svn.php168.com/svga/18.svga', 0, 0); INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(22, 0, 0, 0, '两只天鹅', '', '0.10', 10, 'https://svn.php168.com/small/svga_small/19.gif', 1, 'https://svn.php168.com/svga/19.svga', 0, 0); INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(24, 0, 0, 0, '爱神丘比特', '', '0.10', 10, 'https://svn.php168.com/small/svga_small/21.gif', 1, 'https://svn.php168.com/svga/21.svga', 0, 0); INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(27, 0, 0, 0, '法拉利跑车', '', '2.00', 200, 'https://svn.php168.com/small/svga_small/24.gif', 1, 'https://svn.php168.com/svga/24.svga', 0, 0); INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(28, 0, 0, 0, '飞船', '', '1.00', 100, 'https://svn.php168.com/small/svga_small/25.gif', 1, 'https://svn.php168.com/svga/25.svga', 0, 0); INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(29, 0, 0, 0, '女神', '', '1.00', 100, 'https://svn.php168.com/small/svga_small/26.gif', 1, 'https://svn.php168.com/svga/26.svga', 0, 0); INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(32, 0, 0, 0, '小巫师', '', '0.10', 10, 'https://svn.php168.com/small/svga_small/29.gif', 1, 'https://svn.php168.com/svga/29.svga', 0, 0); INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(33, 0, 0, 0, '超级火箭炮', '', '1.00', 100, 'https://svn.php168.com/small/svga_small/30.gif', 1, 'https://svn.php168.com/svga/30.svga', 0, 0); INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(34, 0, 0, 0, '爱心', '', '0.60', 60, 'https://svn.php168.com/small/svga_small/31.gif', 1, 'https://svn.php168.com/svga/31.svga', 0, 0); INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(35, 0, 0, 0, '保时捷跑车', '', '2.00', 200, 'https://svn.php168.com/small/svga_small/32.gif', 1, 'https://svn.php168.com/svga/32.svga', 0, 0); INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(36, 0, 0, 0, '桃花盛开', '', '0.60', 60, 'https://svn.php168.com/small/svga_small/33.gif', 1, 'https://svn.php168.com/svga/33.svga', 0, 0); INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(37, 0, 0, 0, '我爱你', '', '1.00', 100, 'https://svn.php168.com/small/gif_small/1.gif', 0, 'https://svn.php168.com/gif/1.gif', 7, 0); INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(38, 0, 0, 0, '轻汽球', '', '0.80', 80, 'https://svn.php168.com/small/gif_small/2.gif', 0, 'https://svn.php168.com/gif/2.gif', 15, 0); INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(39, 0, 0, 0, '带我走', '', '0.50', 50, 'https://svn.php168.com/small/gif_small/3.gif', 0, 'https://svn.php168.com/gif/3.gif', 10, 0); INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(40, 0, 0, 0, '陪你去看流星雨', '', '1.00', 100, 'https://svn.php168.com/small/gif_small/4.gif', 0, 'https://svn.php168.com/gif/4.gif', 5, 0); INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(42, 0, 0, 0, '救护车', '', '0.10', 10, 'https://svn.php168.com/small/png_small/1.gif', 2, 'https://svn.php168.com/small/png_small/1.gif', 0, 0); INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(43, 0, 0, 0, '妃子', '', '0.50', 50, 'https://svn.php168.com/small/png_small/2.gif', 2, 'https://svn.php168.com/small/png_small/2.gif', 0, 0); INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(44, 0, 0, 0, '跑车', '', '1.00', 50, 'https://svn.php168.com/small/png_small/3.gif', 2, 'https://svn.php168.com/small/png_small/3.gif', 0, 0); INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(45, 0, 0, 0, '一根香蕉', '', '0.01', 1, 'https://svn.php168.com/small/png_small/4.gif', 2, 'https://svn.php168.com/small/png_small/4.gif', 0, 0); INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(46, 0, 0, 0, '一支花', '', '0.02', 2, 'https://svn.php168.com/small/png_small/5.gif', 2, 'https://svn.php168.com/small/png_small/5.gif', 0, 0); INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(47, 0, 0, 0, '一束花', '', '0.10', 10, 'https://svn.php168.com/small/png_small/6.gif', 2, 'https://svn.php168.com/small/png_small/6.gif', 0, 0); INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(48, 0, 0, 0, '汉堡包', '', '0.03', 3, 'https://svn.php168.com/small/png_small/7.gif', 2, 'https://svn.php168.com/small/png_small/7.gif', 0, 0); INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(49, 0, 0, 0, '一支啤酒', '', '0.02', 2, 'https://svn.php168.com/small/png_small/8.gif', 2, 'https://svn.php168.com/small/png_small/8.gif', 0, 0); INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(50, 0, 0, 0, '一瓶可乐', '', '0.05', 2, 'https://svn.php168.com/small/png_small/9.gif', 2, 'https://svn.php168.com/small/png_small/9.gif', 0, 0); INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(51, 0, 0, 0, '杜蕾斯', '', '0.10', 10, 'https://svn.php168.com/small/png_small/10.gif', 2, 'https://svn.php168.com/small/png_small/10.gif', 0, 9); INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(52, 0, 0, 0, '玉米', '', '0.10', 10, 'https://svn.php168.com/small/png_small/11.gif', 2, 'https://svn.php168.com/small/png_small/11.gif', 0, 0); INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(53, 0, 0, 0, '小狗', '', '0.01', 1, 'https://svn.php168.com/small/png_small/12.gif', 2, 'https://svn.php168.com/small/png_small/12.gif', 0, 0); INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(54, 0, 0, 0, '金条', '', '0.10', 10, 'https://svn.php168.com/small/png_small/13.gif', 2, 'https://svn.php168.com/small/png_small/13.gif', 0, 0); INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(55, 0, 0, 0, '地雷', '', '0.10', 10, 'https://svn.php168.com/small/png_small/14.gif', 2, 'https://svn.php168.com/small/png_small/14.gif', 0, 0); INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(56, 0, 0, 0, '鲜花', '', '0.10', 50, 'https://svn.php168.com/small/png_small/15.gif', 2, 'https://svn.php168.com/small/png_small/15.gif', 0, 0); INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(57, 0, 0, 0, '别墅', '', '0.20', 20, 'https://svn.php168.com/small/png_small/16.gif', 2, 'https://svn.php168.com/small/png_small/16.gif', 0, 0); INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(58, 0, 0, 0, '游艇', '', '1.00', 100, 'https://svn.php168.com/small/png_small/17.gif', 2, 'https://svn.php168.com/small/png_small/17.gif', 0, 0); INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(59, 0, 0, 0, '美人鱼', '', '0.10', 10, 'https://svn.php168.com/small/png_small/18.gif', 2, 'https://svn.php168.com/small/png_small/18.gif', 0, 0); INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(60, 0, 0, 0, '坦克', '', '0.01', 1, 'https://svn.php168.com/small/png_small/19.gif', 2, 'https://svn.php168.com/small/png_small/19.gif', 0, 0); INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(61, 0, 0, 0, '一支花', '', '0.00', 0, 'https://svn.php168.com/small/png_small/20.gif', 2, 'https://svn.php168.com/small/png_small/20.gif', 0, 0); INSERT INTO `qb_vote_liwu` (`id`, `uid`, `aid`, `vote_num`, `title`, `about`, `price`, `jifen`, `picurl`, `type`, `svga`, `swftime`, `list`) VALUES(62, 0, 0, 0, '手表', '', '0.10', 10, 'https://svn.php168.com/small/png_small/21.gif', 2, 'https://svn.php168.com/small/png_small/21.gif', 0, 0);

我不小心把投票自带的礼物全删除了，怎么恢复呀，？还是安装你这个？

投票系统可以调用 这个吗