MySQL Forums
Forum List  »  MySQL Workbench

SE : Unable to synchronize triggers
Posted by: Vincent Courcelle
Date: July 16, 2008 01:36AM

Hello,

I'm havin some troubles with the SE version. There is no problem synchronizing my database tables to my running MySQL but I can't do the same for triggers. The synchronization (one way to MySQL for the moment) fails on (all) the triggers:
"Error 1046: No database selected"

Is there a work around for this bug (if there is any, the documentation is very unexpressive about triggers...)?

My triggers are inserted in the "triggers" tab of my tables ;))


Here is an example of a content of one of them :

-- Trigger DDL Statements
USE MyDatabase;
DELIMITER //

-- Friends
CREATE TRIGGER Table1_Table2_INSERT AFTER INSERT ON Table1 FOR EACH ROW
BEGIN
Blabla...
END;
//

CREATE TRIGGER Table1_Table2_UPDATE AFTER UPDATE ON Table1 FOR EACH ROW
BEGIN
Blabla...
END;
//

Options: ReplyQuote


Subject
Views
Written By
Posted
SE : Unable to synchronize triggers
4461
July 16, 2008 01:36AM


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.