认证重复了怎么办

发现有同样的认证在里面 怎么删除呢~

  删掉！！！！！！！！！

路过路过

怎么删 从哪里删 虚拟主机也

问个问题 基本没有人回答 要么回答的 都是忽悠人的

敲代码的民工 发表于 2011-11-15 16:33
问个问题 基本没有人回答 要么回答的 都是忽悠人的

1. DELETE FROM `root`.`brand_verify` WHERE `brand_verify`.`id` = 1 AND `brand_verify`.`verify` = 'verify1' AND `brand_verify`.`name` = '认证1' AND `brand_verify`.`img` = 'icon_verify1.png' LIMIT 1;
   
2. DELETE FROM `root`.`brand_verify` WHERE `brand_verify`.`id` = 2 AND `brand_verify`.`verify` = 'verify2' AND `brand_verify`.`name` = '认证2' AND `brand_verify`.`img` = 'icon_verify2.png' LIMIT 1;
   
3. DELETE FROM `root`.`brand_verify` WHERE `brand_verify`.`id` = 3 AND `brand_verify`.`verify` = 'verify3' AND `brand_verify`.`name` = '认证3' AND `brand_verify`.`img` = 'ico_claime.gif' LIMIT 1;
   
4. DELETE FROM `root`.`brand_verify` WHERE `brand_verify`.`id` = 4 AND `brand_verify`.`verify` = 'verify4' AND `brand_verify`.`name` = '认证4' AND `brand_verify`.`img` = 'ico_claime.gif' LIMIT 1;
   
5. DELETE FROM `root`.`brand_verify` WHERE `brand_verify`.`id` = 5 AND `brand_verify`.`verify` = 'verify5' AND `brand_verify`.`name` = '认证5' AND `brand_verify`.`img` = 'ico_claime.gif' LIMIT 1;
   
6. DELETE FROM `root`.`brand_verify` WHERE `brand_verify`.`id` = 6 AND `brand_verify`.`verify` = 'verify6' AND `brand_verify`.`name` = '认证6' AND `brand_verify`.`img` = 'ico_claime.gif' LIMIT 1;
   
7. DELETE FROM `root`.`brand_verify` WHERE `brand_verify`.`id` = 7 AND `brand_verify`.`verify` = 'verify7' AND `brand_verify`.`name` = '认证7' AND `brand_verify`.`img` = 'ico_claime.gif' LIMIT 1;
   

复制代码

这里的ROOT 改成你自己的数据库名