MySQL LAST_INSERT_ID() Function

MySQL Functions : Return the AUTO_INCREMENT id of the last row that has been inserted or updated in a table

Definition and Usage

The LAST_INSERT_ID() function returns the AUTO_INCREMENT id of the last row that has been inserted or updated in a table.

Syntax

LAST_INSERT_ID(expression)

Parameter Values

Parameter Description
expression Optional. An expression

Technical Details

Works in: From MySQL 4.0