GEt current auto_increment value for a table?

Discussion in 'MySQL' started by durgesh871, Jun 30, 2010.

0
  1. #1
    How can get current auto_increament value in mysql?
     
    durgesh871, Jun 30, 2010 IP
  2. netload

    netload Member

    Messages:
    105
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    28
    #2
    Do query
    show table status like 'your_table_name'
    Code (markup):
    and use field Auto_increment
     
    netload, Jul 1, 2010 IP