mysql 创建触发器 if判断 同步的更新到对应的表中
发布时间：2022-10-24 11:18:37 所属栏目：MySql教程 来源：
导读： 需求:
公司要求多建几个表顺序依次为表名,表名1,表名2,表名3,表名4当表名的times字段更新的时候如果times=1则更新表名1中对应的数据,如果times=2则更新表名2中对应的数据......特此创建如下触发器
公司要求多建几个表顺序依次为表名,表名1,表名2,表名3,表名4当表名的times字段更新的时候如果times=1则更新表名1中对应的数据,如果times=2则更新表名2中对应的数据......特此创建如下触发器
|
需求: 公司要求多建几个表顺序依次为表名,表名1,表名2,表名3,表名4当表名的times字段更新的时候如果times=1则更新表名1中对应的数据,如果times=2则更新表名2中对应的数据......特此创建如下触发器 示波器内触发和外触发_mysql触发器_上升沿触发和下降沿触发 DELIMITER | CREATE TRIGGER update_other_table AFTER UPDATE ON unit_grid FOR EACH ROW BEGIN IF new.times=1 THEN update unit_grid1 set times=1,thick=new.thick,height=new.height,exciting_force=new.exciting_force where index_length = new.index_length and index_width = new.index_width and uid=new.uid; ELSEIF new.times=2 THEN update unit_grid2 set times=2,thick=new.thick,height=new.height,exciting_force=new.exciting_force where index_length = new.index_length and index_width = new.index_width and uid=new.uid; ELSEIF new.times=3 THEN update unit_grid3 set times=3,thick=new.thickmysql触发器,height=new.height,exciting_force=new.exciting_force where index_length = new.index_length and index_width = new.index_width and uid=new.uid; ELSEIF new.times=4 THEN update unit_grid4 set times=4,thick=new.thick,height=new.height,exciting_force=new.exciting_force where index_length = new.index_length and index_width = new.index_width and uid=new.uid; ELSEIF new.times=5 THEN update unit_grid5 set times=5,thick=new.thick,height=new.height,exciting_force=new.exciting_force where index_length = new.index_length and index_width = new.index_width and uid=new.uid; ELSEIF new.times=6 THEN update unit_grid6 set times=6,thick=new.thick,height=new.height,exciting_force=new.exciting_force where index_length = new.index_length and index_width = new.index_width and uid=new.uid; ELSEIF new.times=7 THEN update unit_grid7 set times=7,thick=new.thick,height=new.height,exciting_force=new.exciting_force where index_length = new.index_length and index_width = new.index_width and uid=new.uid; ELSEIF new.times=8 THEN update unit_grid8 set times=8,thick=new.thick,height=new.height,exciting_force=new.exciting_force where index_length = new.index_length and index_width = new.index_width and uid=new.uid; ELSEIF new.times=9 THEN update unit_grid9 set times=9,thick=new.thick,height=new.height,exciting_force=new.exciting_force where index_length = new.index_length and index_width = new.index_width and uid=new.uid; ELSEIF new.times=10 THEN update unit_grid10 set times=10,thick=new.thick,height=new.height,exciting_force=new.exciting_force where index_length = new.index_length and index_width = new.index_width and uid=new.uid; ELSEIF new.times=11 THEN update unit_grid11 set times=11,thick=new.thick,height=new.height,exciting_force=new.exciting_force where index_length = new.index_length and index_width = new.index_width and uid=new.uid; ELSEIF new.times=12 THEN update unit_grid12 set times=12,thick=new.thick,height=new.height,exciting_force=new.exciting_force where index_length = new.index_length and index_width = new.index_width and uid=new.uid; END IF; END; | DELIMITER ; （编辑：天瑞地安资讯网_保定站长网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
站长推荐