¸ömysqlÌæ´úÓï¾ä

mysqlÖв»ÔÊÐíÔÚÓï¾äÖУ¬ÏÈÖ´Ðб¾±íµÄselect£¬È»ºóÔÙdeleteµÄ²Ù×÷£¬¾ÍÊÇÕâ¸öÒâ˼°É


DELETE from quanxian WHERE uid IN (
SELECT r.uid
from `username` AS u, quanxian AS r
WHERE u.system_id = r.uid
AND u.state !=1
)

±¨´íÈçÏÂ

#1093 - You can't specify target table 'quanxian' for update in from clause

Çó¸ömysql¿ÉÒÔÖ´Ðеı¾Óï¾äÌæ´úÓï¾ä

¸Õ²Å·¢µ½PHPÇøÁË¡£¡£¡£¡£

---

DELETE A from quanxian A
INNER JOIN username U
ON u.system_id=A.UID AND u.state !=1

---

SQL code:
delete a from quanxian a inner join (
select uid from username u inner join quanxian r on u.system_id = r.uid where u.state !=1
) b on a.uid=b.uid

---

£Í£Ù£Ó£Ñ£ÌÓÐһЩÏÞÖÆ£¬Ã»Óа취ÔڣףȣţңźóÔÙÒýÓÃҪɾ³ýµÄ±íÃû¡£Ò»°ãÊÇͨ¹ýÕâÖÖ·½·¨À´½øÐÐɾ³ý¡£

¿ÉÒÔ½øÒ»²½¼ò»¯Îª
SQL code:
delete a from quanxian a inner join username u on u.system_id = a.uid
where u.state !=1