Skip to content

Instantly share code, notes, and snippets.

@jscari

jscari/current_auto_increment.sql

Created December 10, 2015 16:23
Show Gist options
  • Save jscari/c9d062427c21dff88855 to your computer and use it in GitHub Desktop.
Save jscari/c9d062427c21dff88855 to your computer and use it in GitHub Desktop.
Download ZIP
Get the current auto_increment value for any table in Mysql
Raw
current_auto_increment.sql
SHOW TABLE STATUS FROM `DatabaseName` LIKE 'TableName' ;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment