nosmall/return_first_free_id.sql

Created November 1, 2016 15:38

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/nosmall/8095a247566d267536454f585bc487a3.js"></script>
Save nosmall/8095a247566d267536454f585bc487a3 to your computer and use it in GitHub Desktop.

Download ZIP

SQL get first free ID

Raw

return_first_free_id.sql

(SELECT MIN(t1.UID + 1) AS id FROM task_read t1 LEFT JOIN task_read t2 ON t1.UID + 1 = t2.UID WHERE t2.UID IS NULL)

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