积分触发器 mysql 触发器的使用
来源:互联网 发布:java中long的长度 编辑:程序博客网 时间:2024/05/16 05:10
将多个数据库中的某列数据同步时需要用到mysql触发器,以下可做参考,已简单测试ok.
//修改红枣的积分时触发
drop trigger if exists u_hongzaocount;delimiter $$
create trigger u_hongzaocount after update on
hongzao.pre_common_member_count
for each row
begin
declare v int(10);
declare vj int(10);
set v =(select extcredits2 from
qifangjie.pre_common_member_count where uid=new.uid);
set vj =(select extcredits2 from
jifenshop.pre_common_member_count where uid=new.uid);
if (new.extcredits2>old.extcredits2 and new.extcredits2>v) or
(new.extcredits2<old.extcredits2 and new.extcredits2<v) then
update qifangjie.pre_common_member_count set
extcredits2=new.extcredits2 where uid=new.uid;
end if;
if (new.extcredits2>old.extcredits2 and new.extcredits2>vj)
or (new.extcredits2<old.extcredits2 and new.extcredits2<vj)
then
update jifenshop.pre_common_member_count set
extcredits2=new.extcredits2 where uid=new.uid;
end if;
end$$
//添加红枣的积分记录时触发
drop trigger if exists a_hongzaocount;
delimiter $$
create trigger a_hongzaocount before insert on
hongzao.pre_common_member_count
for each row
begin
declare v int(10);
set v =(select extcredits2 from
qifangjie.pre_common_member_count where uid=new.uid);
if v>0 then
set new.extcredits2=v;
end if;
end$$
//修改七纺街的积分时触发
drop trigger if exists u_qifangjiecount;
delimiter $$
create trigger u_qifangjiecount after update on
qifangjie.pre_common_member_count
for each row
begin
declare v int(10);
declare vj int(10);
set v =(select extcredits2 from
hongzao.pre_common_member_count where uid=new.uid);
set vj =(select extcredits2 from
jifenshop.pre_common_member_count where uid=new.uid);
if (new.extcredits2>old.extcredits2 and new.extcredits2>v) or
(new.extcredits2<old.extcredits2 and new.extcredits2<v) then
update hongzao.pre_common_member_count set
extcredits2=new.extcredits2 where uid=new.uid;
end if;
if (new.extcredits2>old.extcredits2 and new.extcredits2>vj)
or (new.extcredits2<old.extcredits2 and new.extcredits2<vj)
then
update jifenshop.pre_common_member_count set
extcredits2=new.extcredits2 where uid=new.uid;
end if;
end$$
//添加七纺街的积分记录时触发
drop trigger if exists a_qifangjiecount;
delimiter $$
create trigger a_qifangjiecount before insert on
qifangjie.pre_common_member_count
for each row
begin
declare v int(10);
set v =(select extcredits2 from
hongzao.pre_common_member_count where uid=new.uid);
if v>0 then
set new.extcredits2=v;
end if;
end$$
//修改积分商城的积分时触发
drop trigger if exists u_jifenshopcount;
delimiter $$
create trigger u_jifenshopcount after update on
jifenshop.pre_common_member_count
for each row
begin
declare v int(10);
declare vj int(10);
set v =(select extcredits2 from
hongzao.pre_common_member_count where uid=new.uid);
set vj =(select extcredits2 from
qifangjie.pre_common_member_count where uid=new.uid);
if (new.extcredits2>old.extcredits2 and new.extcredits2>v) or
(new.extcredits2<old.extcredits2 and new.extcredits2<v) then
update hongzao.pre_common_member_count set
extcredits2=new.extcredits2 where uid=new.uid;
end if;
if (new.extcredits2>old.extcredits2 and new.extcredits2>vj)
or (new.extcredits2<old.extcredits2 and new.extcredits2<vj)
then
update qifangjie.pre_common_member_count set
extcredits2=new.extcredits2 where uid=new.uid;
end if;
end$$
//添加积分商城的积分记录时触发
drop trigger if exists a_jifenshopcount;
delimiter $$
create trigger a_jifenshopcount before insert on
jifenshop.pre_common_member_count
for each row
begin
declare v int(10);
declare vj int(10);
set v =(select extcredits2 from
hongzao.pre_common_member_count where uid=new.uid);
set vj =(select extcredits2 from
qifangjie.pre_common_member_count where uid=new.uid);
if v>=vj then
set new.extcredits2=v;
elseif v<vj then
set new.extcredits2=vj;
end if;
end$$
0 0
- 积分触发器 mysql 触发器的使用
- 【mysql 触发器】触发器使用
- MySQL触发器的使用
- MySQL触发器的使用
- MySQL触发器的使用
- Mysql 触发器的使用
- MySQL触发器的使用
- mysql 触发器的使用
- mysql 触发器的使用
- mysql触发器的使用
- mysql触发器的使用
- MySQL触发器的使用
- mysql 触发器的使用
- mysql 触发器的使用
- mysql触发器的使用
- MYSQL触发器的使用
- mysql触发器的使用
- mysql的触发器使用
- 关于com.actionbarsherlock.widget.SearchView的使用无法调用SearchActivity
- SQL SERVER 2008 怎么导入和导出单张表的数据和结构
- USACO 1.4 Arithmetic Progressions (ariprog)
- JS控制弹窗增加确定和取消
- C语言的服务器开发基础知识
- 积分触发器 mysql 触发器的使用
- 画用例图
- USACO 1.4 Mother's Milk (milk3)
- 如何查看道琼斯指数
- 离线搭建android环境
- SAS决策树:信贷风险建模试验
- c# 统计物理内存百分比
- USACO 1.5 Number Triangles (numtri)
- Android基于Google云端的Voice Search