MySQL Trigger Example

DROP TRIGGER IF EXISTS `park_slap_booking_tmp_after_update`;

DELIMITER ;;

CREATE TRIGGER `park_slap_booking_tmp_after_update` AFTER UPDATE ON `park_slap_booking_tmp` FOR EACH ROW

BEGIN

  INSERT INTO `park_slap_booking_tmp_audit` (`id`, `space_level_setup_id`, `space_slap_setup_id`, `slap_name`, `remarks`, `slap_size`, `per_unit_price`, `app_id`, `process_type_id`, `status`, `is_archive`, `created_at`, `created_by`, `updated_at`, `updated_by`, `audit_event`, `audit_timestamp`) VALUES(NEW.`id`, NEW.`space_level_setup_id`, NEW.`space_slap_setup_id`, NEW.`slap_name`, NEW.`remarks`, NEW.`slap_size`, NEW.`per_unit_price`, NEW.`app_id`, NEW.`process_type_id`, NEW.`status`, NEW.`is_archive`, NEW.`created_at`, NEW.`created_by`, NEW.`updated_at`, NEW.`updated_by`, 'update', CURRENT_TIMESTAMP);

END;;

DELIMITER ;