Skip to content

Instantly share code, notes, and snippets.

@raiderrobert

raiderrobert/readme.md

Created January 31, 2018 14:29
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save raiderrobert/52190048cf703e102b477099d35fba9c to your computer and use it in GitHub Desktop.
Save raiderrobert/52190048cf703e102b477099d35fba9c to your computer and use it in GitHub Desktop.
Download ZIP
DEP - Temporary Table
Raw
readme.md

CREATE TEMPORARY TABLE cross_inventory AS SELECT * FROM inventory WHERE /* complex clause here */;

CREATE INDEX cross_inv_sku ON cross_inventory(sku);

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment