Re: last_insert_id() and load data infile

2004-12-25 Thread Gleb Paharenko
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

last_insert_id() and load data infile

2004-12-22 Thread Martin d'Anjou
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