Skip to content

Instantly share code, notes, and snippets.

@figure002

figure002/gist:7487a97808a870f41804

Last active August 29, 2015 14:03
Show Gist options
  • Save figure002/7487a97808a870f41804 to your computer and use it in GitHub Desktop.
Save figure002/7487a97808a870f41804 to your computer and use it in GitHub Desktop.
Download ZIP
Eliminating subqueries
Raw
gistfile1.sql
-- How to eliminate the following sub queries?
INSERT INTO photos_tags (photo_id, tag_id) VALUES (?, (SELECT id FROM tags WHERE name=?));
-- Becomes:
INSERT INTO photos_tags (photo_id, tag_id) SELECT ?, id FROM tags WHERE name=?;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment