我有一张记录如下的表表名:t1
1 2 3 4 1 2 3 4 1 1 3 4
删除重复的记录,而不更改或向表中添加任何额外的列。期望输出:
1 2 3 4
o0lyfsai1#
你可以和我一起做 DELETE JOIN ```DELETE t1 FROM contacts t1INNER JOINcontacts t2WHEREt1.id < t2.id AND t1.email = t2.email;
DELETE JOIN
1条答案
按热度按时间o0lyfsai1#
你可以和我一起做
DELETE JOIN
```DELETE t1 FROM contacts t1
INNER JOIN
contacts t2
WHERE
t1.id < t2.id AND t1.email = t2.email;