数据:
sql处理:
注意:不能在FROM子句中为update指定目标表“userinfo” You can't specify target table 'userinfo' for update in FROM clause
DELETE FROM userinfo
WHERE id NOT IN (
SELECT* FROM(SELECT id FROM userinfo GROUP BY username)a
)
运行结果:
复杂处理:
数据:
sql处理:
注意:不能在FROM子句中为update指定目标表“userinfo” You can't specify target table 'userinfo' for update in FROM clause
DELETE FROM userinfo
WHERE id NOT IN (
SELECT* FROM(SELECT id FROM userinfo GROUP BY username)a
)
运行结果:
复杂处理: