Skip to content

Instantly share code, notes, and snippets.

@vansosnin

vansosnin/mtm_insert.sql

Created August 27, 2015 17:03
Show Gist options
  • Save vansosnin/55dd8f7a8be7726e31f4 to your computer and use it in GitHub Desktop.
Save vansosnin/55dd8f7a8be7726e31f4 to your computer and use it in GitHub Desktop.
Download ZIP
Mass insert into many-to-many table
Raw
mtm_insert.sql
INSERT INTO users_orders(user_id, order_id) SELECT users.id, orders.id FROM baget JOIN orders
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment