Skip to content

Instantly share code, notes, and snippets.

@portothree

portothree/delete-duplicates-on-mysql-table.txt

Created June 24, 2019 01:54
Show Gist options
  • Save portothree/59674d09046f5c72fc5170a6982967d4 to your computer and use it in GitHub Desktop.
Save portothree/59674d09046f5c72fc5170a6982967d4 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
delete-duplicates-on-mysql-table.txt
CREATE TABLE `noDup` LIKE `Dup` ;
INSERT `noDup` SELECT DISTINCT * FROM `Dup` ;
DROP TABLE `Dup` ;
ALTER TABLE `noDup` RENAME `Dup` ;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment