No way to get multiple insertIds for bulk inserts?

[gnashe]

Is the only option to do separate inserts and keep track of all the insertIds?

[dresende]

I don't believe it's possible. I think it's a protocol limitation.

[felixge]

You should be able to get the individual insert ids when using multiple statements.

[djechlin]

JDBC in Java supports this via the returnGeneratedKeys method. The somewhat clever method used, which has some constraints, is described here: http://stackoverflow.com/a/16592867/1339987 but in a nutshell, you use select row_count() with select last_insert_id() and do math (table needs to be auto_increment traditional or consecutive).

[dougwilson]

@djechlin yea, there is no way we are going to add that to this library; there are too many conditions for using it (need InnoDB backing, need some specific config values set, need to run the select within the same transaction as the insert, need to run the select right after the insert, etc.).