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 ;


0 0
原创粉丝点击