How do you find out which auto increment was assigned on the last insert

Untitled › Forums › Assignment Help › How do you find out which auto increment was assigned on the last insert

Tagged: 

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • August 28, 2012 at 4:37 am #7167
    Aakanksha
    Participant

    How do you find out which auto increment was assigned on the last insert?

    August 28, 2012 at 4:42 am #11859
    Aakanksha
    Participant

    SELECT last_insert_id() will return the last value assigned by the auto_increment function. Note that you don’t have to specify the table name.

  • Author
    Posts
Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.