测试脚本如下

主从 触发器 测试

CREATE TABLE `test_a` (
`x` int(11) default NULL,
`y` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `test_b` (
`x` int(11) default NULL,
`y` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

delimiter //

create trigger copy_test_a after insert on test_a
for each row
begin
insert into test_b(x,y) values(NEW.x,NEW.y);
end
//
delimiter ;

insert into test_b(x,y) values(1,2);
主机
mysql> select * from test_a;
+------+------+
| x | y |
+------+------+
| 1 | 2 |
+------+------+
1 row in set (0.00 sec)

mysql> select * from test_b;
+------+------+
| x | y |
+------+------+
| 1 | 2 |
+------+------+
1 row in set (0.00 sec)

从机器查询结果是一么一样的没有问题
mysql> select * from test_a;
+------+------+
| x | y |
+------+------+
| 1 | 2 |
+------+------+
1 row in set (0.00 sec)

mysql> select * from test_b;
+------+------+
| x | y |
+------+------+
| 1 | 2 |
+------+------+
1 row in set (0.00 sec)