MySQL Forums
Forum List  »  Views

SOLVED
Posted by: aaron M
Date: July 09, 2011 07:06PM

Solved using the following...

DROP TRIGGER IF EXISTS db1.trigger1 //

CREATE TRIGGER db1.trigger1 before insert on db1.user

FOR EACH ROW BEGIN

INSERT INTO db2.user(first, last) values(new.first,new.last);

END
//

This was done in phpmyadmin so you will have to account for DELIMITER



Edited 2 time(s). Last edit at 07/09/2011 07:08PM by aaron M.

Options: ReplyQuote


Subject
Views
Written By
Posted
10217
July 09, 2011 11:56AM
SOLVED
3691
July 09, 2011 07:06PM


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.