Welcome to the Tweaking4All community forums!
When participating, please keep the Forum Rules in mind!
Topics for particular software or systems: Start your topic link with the name of the application or system.
For example “MacOS X – Your question“, or “MS Word – Your Tip or Trick“.
Please note that switching to another language when reading a post will not bring you to the same post, in Dutch, as there is no translation for that post!
[Solved] MySQL - What is the current value of the auto-increment field of my table?
(@hans)
Famed Member Admin
Joined: 12 years ago
Posts: 2859
Topic starter
August 19, 2013 7:39 AM
Sometimes you want to know what the next value of an auto increment field will be of a field in your table. A simple query shows you the last used value (add one to know what the next auto increment value that will be used will be):
SELECT MAX(myfield) FROM mytable;
Where "myfield" should be your field name that has the auto increment value, and "mytable" should be the name of your table.
