Hi,

I've a trigger that writes some data to a temporary table; and at the end
of the trigger writes all the temporary table data in one insert to our
normal Innodb table.

However, for some reason the trigger isn't copying the table from the
temporary table to the Innodb table. If I write in the trigger the inserts
to the Innodb table, it works fine.

Any ideas why. I'm running MySQL 5.6.

Thanks
Neil