举例:
场景:多条件删除购物车表由于之前未做并发处理导致的重复数据问题
DELETE
FROM
ums_cart
WHERE
id IN (
SELECT
id
FROM
(
SELECT
*
FROM
ums_cart a
WHERE
( a.umsUserId, a.smsSpecId ) IN ( SELECT umsUserId, smsSpecId FROM ums_cart GROUP BY umsUserId, smsSpecId HAVING count(0) > 1 )
) t
)
AND id NOT IN (
SELECT
id
FROM
( SELECT max( id ) id FROM ums_cart GROUP BY umsUserId, smsSpecId HAVING count(0) > 1 ) s)
mysql删除重复数据,保留id最大的行数据
于 2021-08-17 17:02:35 首次发布