Remove Duplicate Rows from Mysql — A Developer Place


While inserting into a MySQL table sometimes we got so many duplicate rows . Need not to worry, Just simple alter command help you a lot ALTER IGNORE TABLE table_name ADD UNIQUE INDEX idx_name (columname1, columname2, …..); Lets understand how it works , it alter the columns to unique and unique property automatically truncate all […]

via Remove Duplicate Rows from Mysql — A Developer Place

Advertisements