Chapbook
  • Home
    • Sitemap
  • Snippets
    • MySQL snippets
    • bash snippets
    • PERL snippets
    • PHP snippets
    • pgSQL snippets
  • Category Indexes
    • Cookery
    • Genealogy
    • Photography
    • Technology
    • Uncategorized
  • All Articles
    • Articles by category
    • Publications
      • Cemetery Crosses
      • History of Conecuh County, AL – Index
  • Contact
upArrow

Dedupe example

 August 25, 2010 RLByrd   Snippets, MySQL snippets

DELETE t2.*
FROM the_table t1
  INNER JOIN the_table t2
    ON t2.non_unique_column = t1.non_unique_column
      AND t2.id > t1.id;

Related posts:

  1. Category tree, brute force
  2. Convert charset in all schemas within an instance
« Convert charset in all schemas within an instance Show all grants »

Recent Posts

  • Types of marriage records
  • ONLY_FULL_GROUP_BY and you
  • Lincoln and Free Speech
  • What’s using my swap space?
  • English-to-Gaelic Name Equivalents

Tag Cloud

1st alabama15th alabama33rd alabama36th alabama57th alabamaalabamaapt-getartaudioauditbashblocksbookbrassbyrdcalendarcat mashCDNcentoscharsetchaverscivil warclientcocktailsconfigurationcookingcrimecsacyclonedatabasedavDBeaverDDLdevelopmentdigitaldrinksemailemergeeugeniaexportfilerunfindFlomatonfontsfrisco citygaelicgaleragenealogygmailGooglegrantsgraphicsGUIhardwarehighlandshilliard's legionhistoryIDEinstallationinstrumentsiOSiPadkuberneteslanguagelearninglinuxloadbalancinglocklockingmailmemorymexicanmonitoringmonroemonroe countymultibytemurdermusicmysqlmysqldumpnagiosnamesnetworkold texasopensourceOutlookpacmanpaintingperconaperformancephotosphysicspostfixpostgrespowerpointproductionproxysqlpublicationpythonrailroadrecipesrecordingRedshiftrelayremote accessresearchrestorationscottishsecuritysedshellslavesmithsoftwaresoldierstephen talmadgestuckeyswaptechnologytexastornadotroubleshootingunicodeutf8utilitiesvideovirtualizationwebwebdavwindowsyumzypper

Archives

Indexes

  • About
  • All Articles
  • Categories
  • Contact
  • Cookery Index
  • Genealogy Index
  • Home
  • Music Index
  • Photography Index
  • Search
  • Sitemap
  • Technology Index
  • The Digital Junk Drawer
  • Uncategorized Index

Meta

  • Log in
  • Entries RSS
  • Comments RSS
  • Chapbook
© 1982-2021, rlbyrd.com