去重操作中,报错大意是不能先select一张表再update它。
delete from temp
where openid not in
(select openid from
(
select openid
from temp
group by openid
having count(cardid)=1
)T2
)
这样子做相当于用了一个中间表的查询,应该比起新建一个表再导回来的做法是不知道高到哪里去了
如果把T2去掉,会报错Every derived table must have its own alias,大意派生表必须有自己的表名