[FAQ] How to get the "last insert id"?

[cosa]

CREATE TABLE product ( id INT(4) NOT NULL AUTO_INCREMENT PRIMARY KEY, description VARCHAR(50) );

1.利用SQL的話
mysql> insert into product(description) values('123'); Query OK, 1 row affected (0.00 sec)
mysql> select last_insert_id(); +------------------+ | last_insert_id() | +------------------+ +------------------+ 1 row in set (0.00 sec) ========================================

2.如果是PHP的話你可以用"mysql_insert_id()"取得該id //PHP example....
$result=MYSQL_QUERY("INSERT INTO product (description) ". "VALUES ('$description')");
$id= mysql_insert_id(); print "This file has the following Database ID: $id";