Skip to content

Instantly share code, notes, and snippets.

@zippaaa

zippaaa/sql.sql

Last active September 26, 2016 17:02
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save zippaaa/b0e90d481ddc0ca5440c7a2a5700ec43 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save zippaaa/b0e90d481ddc0ca5440c7a2a5700ec43 to your computer and use it in GitHub Desktop.
Download ZIP
MySql: First Available Id
Raw
sql.sql
SELECT p.page_id + 1 AS FirstAvailableId
FROM pages p
LEFT JOIN pages p1 ON p1.page_id = p.page_id + 1
WHERE p1.page_id IS NULL
ORDER BY p.page_id
LIMIT 0, 1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment