From: Neil Tompkins
Date: May 29 2013 1:19pm
Subject: Temporary Tables with Triggers Problem
List-Archive: http://lists.mysql.com/mysql/229448
Message-Id:
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=001a11c37e30dacb2504dddb3afc
--001a11c37e30dacb2504dddb3afc
Content-Type: text/plain; charset=ISO-8859-1
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
--001a11c37e30dacb2504dddb3afc--