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 $

CREATE EVENT IF NOT EXISTS e_delete_user_token
ON SCHEDULE EVERY 30 DAY_SECOND 
ON COMPLETION PRESERVE
DO CALL delete_user_token();