Never been to TextSnippets before?

Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world (or not, you can keep them private!)

Delete duplicate rows from a table (See related posts)

// Whoops, didja forgot to add a unique index to that column? No problem

SELECT * FROM old_table WHERE 1 GROUP BY [COLUMN TO remove duplicates BY];
DROP TABLE old_table;
RENAME TABLE new_table TO old_table;

You need to create an account or log in to post comments to this site.

Related Posts