LAST_INSERT_ID on multiple rows

[asmith]

Hi,

 

With a single query I'm inserting multiple rows into a table. mysql_insert_id() or LAST_INSERT_ID() in the mysql returns the FIRST row id.

 

I want to store the IDs of the inserted rows by the query in an array. I know how many rows it will be insert and I have the first inserted id, so I guess I can have all the IDs myself.

 

I just doubt it that in a busy server, Is it possible that 2 users running the script have a conflict in inserting the rows? So that one's rows insert in the middle of another's rows... (or MySQL locks it when inserting one's row?)

 

Is there any other way to get all the IDs of that single query?

Thanks

 

[fenway]

As you've discovered, multi-valued inserts will only return the first auto-increment value -- that's for replication -- but if you need the actual IDs for each one, you'll have to run each separately.