Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much
 
PerlMonks  

Re: SELECT LAST_INSERT_ID does not work

by poj (Abbot)
on Jun 28, 2017 at 06:33 UTC ( [id://1193758]=note: print w/replies, xml ) Need Help??


in reply to SELECT LAST_INSERT_ID does not work

From the docs

Important
If you insert multiple rows using a single INSERT statement, LAST_INSERT_ID() returns the value generated for the first inserted row only. The reason for this is to make it possible to reproduce easily the same INSERT statement against some other server.
poj
  • Comment on Re: SELECT LAST_INSERT_ID does not work

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others perusing the Monastery: (2)
As of 2024-05-27 16:00 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found