You can use the LAST_INSERT_ID() function. That's a MySQL specific function, so you'll probably be better off at their site for details. (I believe you can call it in a normal UPDATE statement.)

Looking at the DBI-provided functions, though, I'd use them.