Another LAST_INSERT_ID() Question

insert into tablename (ColA, ColB) values (1,2), (3,4)
select last_insert_id() as lid

lid returns the value for the row with the 1,2 values which is lower
than the row with the 3,4 values.

Is this the expected behavior?

TIA
Lee

> insert into tablename (ColA, ColB) values (1,2), (3,4)
> select last_insert_id() as lid
>
> lid returns the value for the row with the 1,2 values which is lower
> than the row with the 3,4 values.
>
> Is this the expected behavior?

Yes. Is is in the manual, so you could expect it.

--
Willem Bogaerts

Application smith
Kratz B.V.
http://www.kratz.nl/