can you please share the code of the trigger. Any kind of error your getting
On Wed, May 29, 2013 at 6:49 PM, Neil Tompkins <neil.tompk...@googlemail.com > wrote: > 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 >