mysql 删除重复记录保留一条,并做每隔30秒计划任务
DELIMITER $
CREATE PROCEDURE delete_user_token()
BEGIN
DELETE FROM genyuanb2c.user_token WHERE USERTOKEN_UUID IN
(select t.USERTOKEN_UUID from ( SELECT USERTOKEN_UUID FROM genyuanb2c.user_token GROUP BY USER_UUID HAVING COUNT(*)>1 )t);
END $
C...
原创
2021-02-02 08:37:23 ·
91 阅读 ·
0 评论