LAST_INSERT_ID(expr) : LAST_INSERT_ID « Information Functions « MySQL Tutorial

1. MySQL Tutorial
2. Information Functions
3. LAST_INSERT_ID

mysql>
mysql> CREATE TABLE sequence (id INT NOT NULL);
Query OK, 0 rows affected (0.05 sec)

mysql>
mysql> INSERT INTO sequence VALUES (0);
Query OK, 1 row affected (0.00 sec)

mysql>
mysql> UPDATE sequence SET id=LAST_INSERT_ID(id+1);
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql>
mysql> SELECT LAST_INSERT_ID();
+------------------+
| LAST_INSERT_ID() |
+------------------+
|                1 |
+------------------+
1 row in set (0.00 sec)

mysql>
mysql> drop table sequence;
Query OK, 0 rows affected (0.00 sec)

mysql>