Re: LAST_INSERT_ID () in trigger

[Peter Brawley]

drop table if exists t, t2;
create table t(i int primary key auto_increment, j int);
create table t2 like t;
create trigger tins after insert on t insert into t2 select new.i, new.j;