Skip to content

Instantly share code, notes, and snippets.

@HomenSimpsor

HomenSimpsor/getIncrement.sql

Created March 5, 2013 20:41
Show Gist options
  • Save HomenSimpsor/5094070 to your computer and use it in GitHub Desktop.
Save HomenSimpsor/5094070 to your computer and use it in GitHub Desktop.
Download ZIP
Get table autoincrement value
Raw
getIncrement.sql
SELECT TABLE_ROWS
FROM information_schema.tables
WHERE table_name='table'
AND table_schema = DATABASE();
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment