根据子查询进行删除数据
DELETE FROM testname where id = (SELECT t2.id from (SELECT id,count(1) as a FROM testname group by name having a = 1) t2)
根据子查询进行更新数据
UPDATE testname a,(SELECT MAX(id) as a from testname) b set nickname =‘shuaige’ where a.id = b.a
根据子查询进行删除数据
DELETE FROM testname where id = (SELECT t2.id from (SELECT id,count(1) as a FROM testname group by name having a = 1) t2)
根据子查询进行更新数据
UPDATE testname a,(SELECT MAX(id) as a from testname) b set nickname =‘shuaige’ where a.id = b.a