Skip to content

Instantly share code, notes, and snippets.

@zer0her0

zer0her0/EDHDB-MySQL-Clipboard

Last active August 29, 2015 14:23
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save zer0her0/0e2d07105951a4502feb to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save zer0her0/0e2d07105951a4502feb to your computer and use it in GitHub Desktop.
Download ZIP
EDHDB-MySQL-Clipboard
Raw
EDHDB-MySQL-Clipboard
SELECT * FROM edhdb.listing_records WHERE cmdty_id = 1;
SELECT * FROM edhdb.listing_records WHERE cmdty_id = 42;
SELECT * FROM edhdb.station JOIN edhdb.listing_records USING (sta_id);
SELECT * FROM edhdb.station JOIN edhdb.listing_records USING (sta_id) WHERE cmdty_id = 42;
SELECT DISTINCT sta_id FROM edhdb.station JOIN edhdb.listing_records USING (sta_id) WHERE cmdty_id = 42;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment