mysql 创建触发器 if判断 同步的更新到对应的表中

需求:

公司要求多建几个表顺序依次为表名,表名1,表名2,表名3,表名4当表名的times字段更新的时候如果times=1则更新表名1中对应的数据,如果times=2则更新表名2中对应的数据......特此创建如下触发器

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 ;

（编辑：威海站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!