直接查询修改同一张表会报错,这里换个思路,想办法变成是对两张表进行操作就能解决问题啦!
UPDATE test SET IState=11 WHERE Id in (SELECT Id FROM (SELECT * FROM test GROUP BY Tab) as t)
直接查询修改同一张表会报错,这里换个思路,想办法变成是对两张表进行操作就能解决问题啦!
UPDATE test SET IState=11 WHERE Id in (SELECT Id FROM (SELECT * FROM test GROUP BY Tab) as t)