DELETE t1
FROM
`user` t1
INNER JOIN `user` t2
WHERE
t1.id < t2.id
AND ( t1.username = t2.username AND t1.PASSWORD = t2.PASSWORD AND t1.role_id = t2.role_id );
删除数据库中重复的数据
最新推荐文章于 2024-05-12 20:39:09 发布
DELETE t1
FROM
`user` t1
INNER JOIN `user` t2
WHERE
t1.id < t2.id
AND ( t1.username = t2.username AND t1.PASSWORD = t2.PASSWORD AND t1.role_id = t2.role_id );