-- mysql删除重复数据只保留一条
DELETE
FROM
general_dd_dept_teacher
WHERE
id NOT IN ( select a.id from (SELECT min( id ) AS id FROM general_dd_dept_teacher GROUP BY dd_dept_id, dd_teacher_id,sys_id) a )
mysql删除重复数据只保留一条
最新推荐文章于 2024-07-03 03:38:36 发布