526互联

错误：You can't specify target table 'xxx' for update in FROM clause的解决

发布时间 2023-10-20 09:37:08作者: 小九讲测试
delete FROM usrlogin where member_id=(SELECT member_id FROM usrlogin WHERE login_id='#011SkhVVje27smbxek0XwjKeA==');

　　

会出现报错信息：
　　You can't specify target table 'tempA' for update in FROM clause
　　大致意思是，在同一语句中，不能先select出同一表中的某些值，再update这个表。
解决方法：
DELETE FROM usrlogin WHERE member_id=(SELECT a.member_id FROM (SELECT member_id FROM usrlogin WHERE login_id='#011SkhVVje27smbxek0XwjKeA==')AS a );