Re: SELECT LAST_INSERT_ID does not work


"be consistent"
	PerlMonks

Re: SELECT LAST_INSERT_ID does not work

by poj (Abbot)

Log in
Create a new user
The Monastery Gates
Seekers of Perl Wisdom
Meditations
Cool Uses For Perl
Obfuscation
Tutorials
Poetry
Illuminations
Reviews
Perl News
Donate
Recent Threads
Newest Nodes
Super Search
PerlMonks Discussion
What's New

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