Skip to content

Instantly share code, notes, and snippets.

@gustavobgama

gustavobgama/AutoIncrement.sql

Created December 18, 2013 19:03
Show Gist options
  • Save gustavobgama/b1e2ce7ddd1330916864 to your computer and use it in GitHub Desktop.
Save gustavobgama/b1e2ce7ddd1330916864 to your computer and use it in GitHub Desktop.
Download ZIP
View auto increment value of a table
Raw
AutoIncrement.sql
SELECT `AUTO_INCREMENT`
FROM `information_schema`.`TABLES`
WHERE `TABLE_SCHEMA` = SCHEMA()
AND `TABLE_NAME` = 'tbl_name';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment