Skip to content

Instantly share code, notes, and snippets.

@klochner

klochner/destroy_habtm.sql

Created February 5, 2010 00:38
Show Gist options
  • Save klochner/295323 to your computer and use it in GitHub Desktop.
Save klochner/295323 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
destroy_habtm.sql
Join Table Columns (2.3ms) SHOW FIELDS FROM `foos_bars`
Resident Load (18.7ms) SELECT * FROM `bars` INNER JOIN `foos_bars` ON `bars`.id = `foos_bars`.bar_id WHERE (`foos_bars`.foo_id = 1327 )
SQL (0.1ms) BEGIN
SQL (51.2ms) DELETE FROM `foos_bars` WHERE foo_id = 1327 AND bar_id in (117261,117262,117263, . .
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment