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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s