Skip to content

Instantly share code, notes, and snippets.

@rossmartin

rossmartin/MySQL UNION with LIMITs

Last active December 11, 2015 19:39
Show Gist options
  • Save rossmartin/4650090 to your computer and use it in GitHub Desktop.
Save rossmartin/4650090 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL Combine Two Statements With LIMITs using UNION
Raw
MySQL UNION with LIMITs
(SELECT 'lab' AS table_name, id FROM table1
WHERE organizerClassId = '4013-5' LIMIT 1)
UNION
(SELECT 'rad' AS table_name, id FROM table2
WHERE organizerClassId = '4013-5' LIMIT 1);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment