See the current auto_increment-value

Help
2010-10-11
2013-06-06
  • Nobody/Anonymous

    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.

     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks