mysql中删除重复数据只保留一条数据,删除的时候一定要先备份数据,多次验证后才能执行正式库
DELETE FROM cgform_lg_field_copy1 WHERE id NOT IN ( SELECT t.max_id FROM (SELECT MAX(id) AS max_id FROM cgform_lg_field_copy1 WHERE buss_code = 'E0202' and TEMPLCLASSIFY='0' GROUP BY field_name ) AS t ) AND buss_code = 'E0202' and TEMPLCLASSIFY='0'; DELETE FROM cgform_lg_field_copy1 WHERE id NOT IN ( SELECT t.max_id FROM (SELECT MAX(id) AS max_id FROM cgform_lg_field_copy1 WHERE buss_code = 'E0202' and TEMPLCLASSIFY='1' GROUP BY field_name ) AS t ) AND buss_code = 'E0202' and TEMPLCLASSIFY='1';
本文由 admin 创作,采用 知识共享署名4.0
国际许可协议进行许可
本站文章除注明转载/出处外,均为本站原创或翻译,转载前请务必署名
最后编辑时间为:2022-11-04 22:26:16