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