Hello.
As said at:
http://dev.mysql.com/doc/mysql/en/Information_functions.html
"If you insert many rows at the same time with an insert statement,
LAST_INSERT_ID() returns the value for the first inserted row."
LOAD DATA INFILE inserts several rows a time, so this is a usual
behavio
Hi,
I am trying to find in the manual what select last_insert_id() will return
after a load data infile command is executed.
>From my experiments, it returns the id of the FIRST record in the file, I
would have expected the LAST, but that is not the case.
Is that documented somewhere? Can I re