mysqlで重複データの削除
mysqlで重複データの削除
テーブルrouteのフィールドtravelの重複データの削除
delete from route where id not in (select min_id from (select min(t1.id) as min_id from route as t1 group by t1.travel) as t2);
mysqlで重複データの削除
テーブルrouteのフィールドtravelの重複データの削除
delete from route where id not in (select min_id from (select min(t1.id) as min_id from route as t1 group by t1.travel) as t2);
コメント
mysqlで重複データの削除 — コメントはまだありません
HTML tags allowed in your comment: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>