is it possible to display the next value for auto_increment-fields within "Show Structure"?
It also would be nice to show the next ai-value when I want to alter a table (just in case i want to change it).
Otherwise I always have to
SELECT MAX(MY_AI_FIELD) + 1 FROM MY_TABLE
Adminer displays the auto_increment value in tables list in the database overview. It is pre-filled in the form if you click on the AI value in this list.
It is not displayed by default in the form because it can modify your data without noticing - for example if someone else inserts a value in the table and deletes it while you have the form open, the AI value will be overwritten after sending a form.
Log in to post a comment.