Categories
Uncategorized

Remove MySQL Duplicates

ALTER IGNORE TABLE `table_name` ADD UNIQUE (title, SID)

Do not allow duplicates

In Settings tab, you can try checking the following values:

  • Settings -> SQL Queries -> Ignore multiple statement errors

If you are using CSV format:

  • Settings -> Import -> CSV -> Do not abort on INSERT error

If you are using SQL format:

  • Settings -> Export -> SQL -> Use ignore inserts