How to delete duplicate records in mysql database? June 1, 2023 by Tarik What you can do is copy the distinct records into a new table by: select distinct * into NewTable from MyTable