Query for Delete Dublicate item/row from a table in mysql database.

DELETE n1 FROM file n1, file n2 WHERE n1.id_file > n2.id_file AND n1.file_name = n2.file_name

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