Skip to content

Instantly share code, notes, and snippets.

@takahashiyuya

takahashiyuya/gist:24ea9b53da079653c1f3

Created June 27, 2014 10:31
Show Gist options
  • Save takahashiyuya/24ea9b53da079653c1f3 to your computer and use it in GitHub Desktop.
Save takahashiyuya/24ea9b53da079653c1f3 to your computer and use it in GitHub Desktop.
Download ZIP
自動採番値（要するに次のid）を取得するSQL
Raw
gistfile1.txt
SELECT AUTO_INCREMENT FROM information_schema.TABLES WHERE TABLE_SCHEMA = "databaseName" AND TABLE_NAME = "tableName";
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment