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 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区了。
INNER JOIN username U
ON u.system_id=A.UID AND u.state !=1
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
delete a from quanxian a inner join username u on u.system_id = a.uid
where u.state !=1