Shulou(Shulou.com)06/01 Report--

Distribute synchronization data through triggers

Create table tab (id int not null primary key,name varchar 20, age int,address varchar 200)

Create table tab0 (id int not null primary key,name varchar 20, age int,address varchar 200)

Create table tab1 (id int not null primary key,name varchar 20, age int,address varchar 200)

Create table tab2 (id int not null primary key,name varchar 20, age int,address varchar 200)

Insert into tab values (1, recorder, recorder,)

Insert into tab values (2 recordings jiangzhongjia 40 phianghai`)

Insert into tab values (3 recordings wangzhongpai 31 phianghai`)

Delimiter / /

Create trigger tri_sync_insert

After insert on tab

For each row

Begin

Declare

V_result int

Set v_result=mod (new.id,3)

If v_result = 0 then

Insert into tab0 (id,name,age,address) values (new.id,new.name,new.age,new.address)

Elseif v_result = 1 then

Insert into tab1 (id,name,age,address) values (new.id,new.name,new.age,new.address)

Else

Insert into tab2 (id,name,age,address) values (new.id,new.name,new.age,new.address)

End if

End

/ /

Delimiter

Delimiter / /

Create trigger tri_sync_update

After update on tab

For each row

Begin

Declare

V_result int

Set v_result=mod (new.id,3)

If v_result = 0 then

Replace into tab0 (id,name,age,address) values (new.id,new.name,new.age,new.address)

Elseif v_result = 1 then

Replace into tab1 (id,name,age,address) values (new.id,new.name,new.age,new.address)

Else

Replace into tab2 (id,name,age,address) values (new.id,new.name,new.age,new.address)

End if

End

/ /

Delimiter

Delimiter / /

Create trigger tri_sync_delete

After delete on tab

For each row

Begin

Declare

V_result int

Set v_result=mod (old.id,3)

If v_result = 0 then

Delete from tab0 where id=old.id

Elseif v_result = 1 then

Delete from tab1 where id=old.id

Else

Delete from tab2 where id=old.id

End if

End

/ /

Delimiter

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.