mysql触发错误模式的问题 [英] mysql Trigger issue in wrong schema

问题描述

模式错误触发是什么意思?

DELIMITER $$

CREATE TRIGGER `wordpress_database1`.`insert_user_from_database2` AFTER INSERT ON `wordpress_database2`.`wp_users`
FOR EACH
ROW
BEGIN

  INSERT INTO `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;$$

推荐答案

触发器必须与要插入的触发器位于相同的架构(即，您将在wordpress_database2上创建触发器).您仍然可以插入其他架构.有了这个简单的更改，其余所有内容都应该可以正常工作.

Trigger needs to be on the same schema as where you are inserting (i.e. you would create the trigger on wordpress_database2). You can still insert to other schemas. With that simple change, the entire rest of it should work.

这篇关于mysql触发错误模式的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！