删除表中重复id值时间:2023-03-10 04:53:29 DELETE t FROM (SELECT *,ROW_NUMBER()OVER(PARTITION BY test1,test2,test3,test4 ORDER BY RAND()) AS RN FROM TableName) AS t WHERE RN>1