See the current auto_increment-value

Help
2010-10-11
2013-06-06
  • Hi there,

    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
    
     
  • Jakub Vrána
    Jakub Vrána
    2010-10-25

    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.