mysql 修改重复数据 isdel

SELECT

min(id)minid,

userid

FROM

vouchers

WHERE

reason = ‘XX‘

GROUP BY

userid

) ss ) ) c set b.isdel=1 where b.id =c.id

mysql 修改重复数据 isdel

标签：