Skip to content

Instantly share code, notes, and snippets.

@HomenSimpsor
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.
Get table autoincrement value
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