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

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 );