Friday, 15 February 2013

mysql - Triggers error 1064 -



mysql - Triggers error 1064 -

question 1: several database each website on 1 server. when user created, want replicate info database. triggers sql phpadmin ?

question 2: did miss in request ?

my request :

create trigger `wordpress_database1`.`insert_user_from_database2` after insert on `wordpress_database2`.`wp_users` each row begin insert `wordpress_database1`.`wp_users` ( id, user_login, user_pass, user_nicename, user_email, user_url, user_registered, user_activation_key, user_status, display_name ) values ( new.id, new.user_login, new.user_pass, new.user_nicename, new.user_email, new.user_url, new.user_registered, new.user_activation_key, new.user_status, new.display_name ); end;$$

i error phpadmin sql:

#1435 - trigger in wrong schema

you have not ended trigger,

delimiter $$ create trigger `wordpress_database1`.`insert_user_from_database2` after insert on `wordpress_database2`.`wp_users` each row begin insert `wordpress_database1`.`wp_users` ( id, user_login, user_pass, user_nicename, user_email, user_url, user_registered, user_activation_key, user_status, display_name) values ( new.id, new.user_login, new.user_pass, new.user_nicename, new.user_email, new.user_url, new.user_registered, new.user_activation_key, new.user_status, new.display_name ); end $$ delimiter ;

mysql sql triggers phpmyadmin

No comments:

Post a Comment