Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister
 
PerlMonks  

Re: DBI insert: Need to retrieve an autoincremented column from a table after an insert.

by Jenda (Abbot)
on Aug 09, 2008 at 18:27 UTC ( [id://703309]=note: print w/replies, xml ) Need Help??


in reply to DBI insert: Need to retrieve an autoincremented column from a table after an insert.

I would be very surprised if you found a database where the last_insert_id is not session specific. That is you always get YOUR last inserted id. You can test it by a script that'd make two connections, insert one row by each connection and then looked at the last_insert_id() for each connection.

  • Comment on Re: DBI insert: Need to retrieve an autoincremented column from a table after an insert.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://703309]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others meditating upon the Monastery: (4)
As of 2024-04-20 03:42 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found