Knowledge Base Nr: 00338 remove_duplicates_fromdb.txt - http://www.swe-kaiser.de

MySQL: duplicates aus tabelle entfernen

  
create table bu_report10 as SELECT DISTINCT `report_id` , `dlg_type` , `dlg_config` , `dlg_title` , `dlg_tooltip` , `print_only` , `screen_only` , `user_data`
FROM tbl_job_report_template
WHERE report_id =10
ORDER BY step_id, sort_id;

delete FROM tbl_job_report_template WHERE report_id =10;

insert
into tbl_job_report_template (`report_id` , `step_id` , `sort_id` , `dlg_type` , `dlg_config` , `dlg_title` , `dlg_tooltip` , `print_only` , `screen_only` , `user_data`)  select * from bu_report10;