Inserting - getting back the AutoInc Number

[Coderifous]

When I'm inserting into a table that has the AutoIncrement as the Primary Key, I'd like to get that value returned to me. I'm using the Perl DBI. I'd like to think that there is a function that does this, but I don't know it.

--jim

 

[danielhozac]

I have never used the Perl DBI, but the MySQL way of doing it is "SELECT LAST_INSERT_ID();". //Daniel

 

[piti]

i'm not familiar with perl but mysql has function LAST_INSERT_ID() which returns the id of the last inserted row (assuming there's an autoincremented column)
so after running the insert query, use SELECT LAST_INSERT_ID();

this is returned on a perconnection basis, so you may have multiple users insert data, but the returned id is from the row you have entered

 

[Coderifous]

Very nice fellas. That'll do.

Thanks.

--jim