Skip to content

Instantly share code, notes, and snippets.

@julienbourdeau

julienbourdeau/dedup.sql

Created March 2, 2019 20:57
Show Gist options
  • Save julienbourdeau/9cda9fe056e345daad15ca20af6e68f0 to your computer and use it in GitHub Desktop.
Save julienbourdeau/9cda9fe056e345daad15ca20af6e68f0 to your computer and use it in GitHub Desktop.
Download ZIP
Delete duplicate entries from db with single SQL query
Raw
dedup.sql
-- example from www.lasceneparisienne.com DB
DELETE n1 FROM calendar_events n1,
calendar_events n2
WHERE n1.id < n2.id
AND n1.id_facebook = n2.id_facebook
AND n1.calendar_id = 2;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment