how to use LAST_INSERT_ID( )

[seshu]

thank sir
now one more dubt how to use last_insert_id( )
because i want get all the last inserted and then update only those values
can you say me how?
regards
seshu

[ronverdonk]

thank sir
now one more dubt how to use last_insert_id( )
because i want get all the last inserted and then update only those values
can you say me how?
regards
seshu

Be careful by what you mean by "all the last inserted"!
There is only one last inserted and you will get that id only after an INSERT or an UPDATE command. As the manual states:

LAST_INSERT_ID() (with no argument) returns the first automatically generated value that was set for an AUTO_INCREMENT column by the most recently executed INSERT or UPDATE statement to affect such a column.

See also the MySQL documentation about usage at Information functions

Ronald :cool: