MySQL Forums
Forum List  »  Triggers

Re: (UPDATED with Schema) Triggers before update error (Error Code: 1054. Unknown column 'workflow_id' in 'NEW')
Posted by: Peter Brawley
Date: January 28, 2014 02:38PM

> We used FLUSH TABLES to show that when we used it before an update statement, the trigger runs without error on the automatic status logic.

InnoDB is a transactional storage engine: you set the desired transaction isolation level, then put control table writes inside transaction blocks with Start Transaction, Rollback and Commit commands, NOT with blunderbuss methods like LOCK, FLUSH &c.

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.