MySQLでINSERTした直後にINSERTしたデータのAUTO_INCREMENT値を取得する

PHP
mysql_insert_id()

$query = 'insert into table_name ...';
$result = mysql_query($query);
$last_id = mysql_insert_id();

MySQL
last_insert_id()

$query = 'insert into table_name ...';
$result = mysql_query($query);
$query = 'select last_insert_id() from table_name';
$result = mysql_query($query);
$row = mysql_fetch_array($result);

参考：http://blog.tofu-kun.org/071206185929.php