Last inserted ID in MySQL

To retrieve the last inserted ID of the auto_increment column:

mysql> select last_insert_id();

The PHP equivalent is:

mysql_insert_id

The above must be invoked from the same thread that performed the insertion.

This entry was posted on Sunday, May 6th, 2007 at 3:57 pm and is filed under mysql, php. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “Last inserted ID in MySQL”

  1. Manjula Says:
    March 5, 2008 at 2:07 pm | Reply

    I wont to know how to take last inserted id(auto increment) wont to take insert time as output.

    Thanks
    Manjula

Leave a Reply