php delete select 的有关问题

php delete select 的问题

delete from sinykk_love_web where id in (select id from sinykk_love_web group by site_url having count(site_url)>1)


1093 - You can't specify target table 'sinykk_love_web' for update in FROM clause


改成如下就好


delete from sinykk_love_web where id in (select temp.id from (select m. id,m.site_url from sinykk_love_web m)? temp group by temp.site_url having count(temp.site_url)>1)

声明：本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系[e-mail]核实处理。

相关文章

相关视频

---

• 两款万能的php分页类，两款php分页_PHP教程
• php生成图片缩略图的方法，_PHP教程
• PHP4.0.1的变化（三）_PHP教程
• PHP 编码规范(9)_PHP教程
• php delete select 的有关问题

• from型子查询
• from子句
• awakeFromXib的方法介绍
• phome_enewsbefrom
• 数组中Array.from的认识