Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DROP TRIGGER IF EXISTS `placasptc`.`update_bds`//
- CREATE TRIGGER `placasptc`.`update_bds` BEFORE UPDATE ON `placasptc`.`bds`
- FOR EACH ROW begin
- insert into historico
- set hist_action ='update',
- bkp_ID = old.ID,
- bkp_empresa = old.empresa,
- bkp_prefixo = old.prefixo,
- bkp_placa = old.placa,
- hist_modificado = now(),
- hist_usuario = Current_user();
- end
Add Comment
Please, Sign In to add comment