Trigger-demo--新增 更新 和删除的一个 例子
来源:互联网 发布:网络视频节目策划 编辑:程序博客网 时间:2024/05/17 02:54
--create table persons
drop table if EXISTS `persons`;
CREATE TABLE `persons`(
P_id int(5) primary key,
LastName varchar(255),
FirstName varchar(255),
Address varchar(255),
City varchar(255)
);
--create table person_record to record the persons's changed
drop table if exists `person_record`;
CREATE table person_record(
R_id int(5) AUTO_INCREMENT PRIMARY KEY,
P_id int(5),
LastName varchar(255),
FirstName varchar(255),
Address varchar(255),
City varchar(255),
Operate_type varchar(10)
);
--create trigger insert, update, delete for persons
DROP TRIGGER IF EXISTS `persons_insert_trigger`;
DROP TRIGGER IF EXISTS `persons_update_trigger`;
DROP TRIGGER IF EXISTS `persons_delete_trigger`;
CREATE TRIGGER persons_insert_trigger AFTER INSERT ON persons for each row
begin
insert into person_record(P_id,LastName,FirstName,Address,City,Operate_type)
values (new.P_id,new.LastName,new.FirstName,new.Address,new.City,'CREATE');
end;
create trigger person_update_trigger after update on persons for each row
begin
insert into person_record(P_id,LastName,FirstName,Address,City,Operate_type)
values (old.P_id,new.LastName,new.FirstName,new.Address,new.City,'UPDATE');
end;
create trigger person_delete_trigger after delete on persons for each row
begin
insert into person_record(P_id,LastName,FirstName,Address,City,Operate_type)
values (old.P_id,old.LastName,old.FirstName,old.Address,old.City,'DELETE');
end;
drop table if EXISTS `persons`;
CREATE TABLE `persons`(
P_id int(5) primary key,
LastName varchar(255),
FirstName varchar(255),
Address varchar(255),
City varchar(255)
);
--create table person_record to record the persons's changed
drop table if exists `person_record`;
CREATE table person_record(
R_id int(5) AUTO_INCREMENT PRIMARY KEY,
P_id int(5),
LastName varchar(255),
FirstName varchar(255),
Address varchar(255),
City varchar(255),
Operate_type varchar(10)
);
--create trigger insert, update, delete for persons
DROP TRIGGER IF EXISTS `persons_insert_trigger`;
DROP TRIGGER IF EXISTS `persons_update_trigger`;
DROP TRIGGER IF EXISTS `persons_delete_trigger`;
CREATE TRIGGER persons_insert_trigger AFTER INSERT ON persons for each row
begin
insert into person_record(P_id,LastName,FirstName,Address,City,Operate_type)
values (new.P_id,new.LastName,new.FirstName,new.Address,new.City,'CREATE');
end;
create trigger person_update_trigger after update on persons for each row
begin
insert into person_record(P_id,LastName,FirstName,Address,City,Operate_type)
values (old.P_id,new.LastName,new.FirstName,new.Address,new.City,'UPDATE');
end;
create trigger person_delete_trigger after delete on persons for each row
begin
insert into person_record(P_id,LastName,FirstName,Address,City,Operate_type)
values (old.P_id,old.LastName,old.FirstName,old.Address,old.City,'DELETE');
end;
- Trigger-demo--新增 更新 和删除的一个 例子
- 一个实现数据增量加载的ETL算法(记录新增、更新和删除标志)
- jqGrid的使用方法(编辑,删除,更新,新增)
- jqGrid的使用方法(编辑,删除,更新,新增)
- jqGrid的使用方法(编辑,删除,更新,新增)
- solrj新增、删除、更新
- kdb+q一个入库和删除的小demo
- 一个动态添加panel 和 删除panel的例子
- 一个JTree节点添加、删除和修改的例子
- 一个简单的jQuery例子,动态添加表格和删除
- cassandra新增、更新、删除数据。
- lucene 新增 更新 删除索引
- Android中Service的一个Demo例子
- datagridview的使用,即时新增,更新,删除数据库数据
- jQuery学习笔记--jqGrid的使用方法(编辑,删除,更新,新增)
- jQuery学习笔记--jqGrid的使用方法(编辑,删除,更新,新增)
- ClearCase Trigger指南(7)-修改与删除一个Trigger
- 返璞归真asp.net mvc 1.0(1) - 添加、查询、更新和删除的Demo
- C++报错集合:error: 'CppUnit::TestFixture' is an inaccessible base of 'LMQueryConnectionTest'
- 苹果平台上的媒体流播放技术HLS
- unsigned char陷阱
- struts-ajax配置实例
- Android HAL 实例——mokoid LEDTest
- Trigger-demo--新增 更新 和删除的一个 例子
- C语言常用排序全解
- poj3590
- FreeType字形约定
- 黑马程序员------面向对象之封装 继承 多态
- 谷歌收购摩托罗拉移动扫清障碍:获专利盾牌
- moss 无法对开始地址 <http://....> 进行爬网。
- 《AppStore审核指南》中文版
- MySQL server has gone away的几种解决办法