INSERT with LAST_INSERT_ID

The MySQL-specific option LAST_INSERT_ID(expr) can be used after an INSERT to  after the insert takes place;

mysql> INSERT INTO City (name, countrycode)

-> VALUES ('Sarah City', 'USA');

Query OK, 1 row affected (#.## sec)

mysql> SELECT LAST_INSERT_ID();

+---------------------------+

| LAST_INSERT_ID() |

+----------------------------+

| 4080                            |

+-----------------------------+

If a table contains an AUTO_INCREMENT column and INSERT ... UPDATE inserts a row, the LAST_INSERT_ID() function returns the AUTO_INCREMENT value. If the statement updates a row instead, LAST_INSERT_ID() is not meaningful. However, LAST_INSERT_ID(expr) can be used to worked around this.