MySQL 触发器实现表同步

       利用触发器实现表同步。

触发器的语法是：

                                    create trigger <触发器名称>

                                   ｛before | after｝

                                    { insert | update | delete }

                                    on <表名>

                                    for each row

                                    <触发器SQL语句>

解释：

               create trigger <触发器名称>：创建一个新触发器，并指定触发器的名称。
               { before | after}：用于指定在insert、update或delete语句执行前触发还是在语句执行后触发。
               on <表名>：用于指定响应该触发器的表名。
               for each row：触发器的执行间隔，for each row 通知触发器每隔一行执行一次动作，而不是对整个表执行一次。
               <触发器SQL语句>：触发器要执行的SQL语句，如果该触发器要执行多条SQL语句，要将多条语句放在begin…end块中。

例子：

             1.创建表：

                                    create TABLE user(
                                    user_id varchar(10) not null,
                                    user_name varchar(20) DEFAULT NULL,
                                    user_group varchar(10) DEFAULT NULL, 
                                    user_home  varchar(30) DEFAULT NULL
                                     )

                                  

                                同步表：create TABLE user_syn(
                                               user_id varchar(10) not null,
                                               user_name varchar(20) DEFAULT NULL,
                                               user_group varchar(10) DEFAULT NULL,
                                               user_home  varchar(30) DEFAULT NULL
                                               )

                  2.创建触发器：CREATE TRIGGER user_syn_trigger
                                           BEFORE INSERT
                                           ON user
                                           FOR EACH ROW
                                           INSERT INTO user_syn values(new.user_id,new.user_name,new.user_group,new.user_home) 

                     检 查：                         

                                                  

                3.验证表同步：

                  insert into user values(1,'xiaoxiao','Root','JiangXi');

                 查看效果：