delete
from user_info
where id in
(select temp.id from (select id
from user_info
group by login_id
having count(1) > 1) temp);
删除多字段分组后的重复数据,仅保留一条
DELETE
FROM member
WHERE id IN (
SELECT id
FROM (
SELECT id
FROM member a
WHERE (
a.p_id,
a.user_id
) IN (
SELECT p_id,
user_id
FROM member
GROUP BY p_id, user_id
HAVING count(*) > 1
)
AND id NOT IN (
SELECT min(id)
FROM member
GROUP BY p_id, user_id
HAVING count(*) > 1
)
) AS temp
)
多表关联删除
删除info表关联的task表的所有数据
delete a,b
from process_info a
join process_task b on a.process_id = b.process_id
where a.process_code = '11111111';
mysql清空表数据并重置自增ID
## 方式一
delete from 表名;
alter table 表名 auto_increment=1;
## 方式二
truncate table 表名;