Re: Multipline lines insert in a table with Autoincrement field

[Peter Brawley]

drop table if exists t;
create table t(id smallint unsigned primary key auto_increment);
insert into t values(null),(null),(null);
select last_insert_id();
+------------------+
| last_insert_id() |
+------------------+
|                1 |
+------------------+

Is your loop executing twice? Is it doing one insert at a time?