List:General Discussion« Previous MessageNext Message »
From:Neil Tompkins Date:May 29 2013 1:19pm
Subject:Temporary Tables with Triggers Problem
View as plain text  
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

Thread
Temporary Tables with Triggers ProblemNeil Tompkins29 May
  • Re: Temporary Tables with Triggers ProblemAnanda Kumar29 May
    • Re: Temporary Tables with Triggers ProblemNeil Tompkins29 May
      • Re: Temporary Tables with Triggers ProblemAnanda Kumar29 May
        • Re: Temporary Tables with Triggers ProblemNeil Tompkins29 May
          • Re: Temporary Tables with Triggers ProblemAnanda Kumar29 May
            • Re: Temporary Tables with Triggers ProblemNeil Tompkins29 May
      • Re: Temporary Tables with Triggers Problemhsv29 May