MySQL TRIGGER
来源:互联网 发布:word for mac如何使用 编辑:程序博客网 时间:2024/05/16 13:46
delimiter //
DROP TRIGGER IF EXISTS ship_update_after_upload;
CREATE TRIGGER ship_update_after_upload
AFTER INSERT ON sy_ship_upload_record
FOR EACH ROW
BEGIN
update sy_ship set modify_date=NOW(), longitude=new.longitude, latitude=new.latitude, speed=new.speed, direction=new.direction, voltage=new.voltage, power_type=new.power_type, info_source=new.info_source where id = new.ship_info;
END;//
delimiter ;
DROP TRIGGER IF EXISTS ship_update_after_upload;
CREATE TRIGGER ship_update_after_upload
AFTER INSERT ON sy_ship_upload_record
FOR EACH ROW
BEGIN
update sy_ship set modify_date=NOW(), longitude=new.longitude, latitude=new.latitude, speed=new.speed, direction=new.direction, voltage=new.voltage, power_type=new.power_type, info_source=new.info_source where id = new.ship_info;
END;//
delimiter ;
0 0
- mysql trigger
- mysql trigger
- mysql trigger
- mysql trigger
- mysql trigger
- Mysql Trigger
- MySQL TRIGGER
- MySQL TRIGGER
- mysql create trigger
- mysql insert trigger
- 【转】mysql-trigger-触发器
- TRIGGER:Mysql触发器
- mysql之触发器trigger
- MYSQL触发器(Trigger)
- mysql 之触发器 trigger
- mysql之触发器trigger
- MySQL触发器 trigger学习
- mysql之触发器trigger
- python数据处理工具包——pandas简介(如何构建数据结构篇)
- mysql连接失败 10038问题
- 剑指offer-面试题3 查找二维数组中的数
- AsyncTask源码解剖
- C语言中实现参数个数可变函数
- MySQL TRIGGER
- 从零开始学Spring Boot(4)常用配置
- C实现RGB32 Gama校正
- AsyncTask源码分析
- Java集合简介
- spring mybatis
- Spring-MVC 整合JSON 实例
- tensorflow +mnist
- 深入理解 Yii2.0