UPDATE USER SET User.status=0 WHERE User.idUser IN( SELECT User.idUser FROM (SELECT * FROM USER) AS B WHERE B.status IS NULL);
You can't specify target table 'User' for update in FROM clause
日志大意 :在update语句中的 from 不能指明为 User
UPDATE USER SET User.status=0 WHERE User.idUser IN( SELECT User.idUser FROM (SELECT * FROM USER) AS B WHERE B.status IS NULL);