Форум пользователей MySQL

CREATE TABLE `trg_02_1_test` (
    `id_tbl_02_1` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
    `cur_datetime_tbl_02_1` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `pol_1_date_tbl_02_1` DATE NULL DEFAULT NULL,
    `pol_2_enum_tbl_02_1` ENUM('Y','N') NULL DEFAULT NULL,
    `pol_3_longtxt_tbl_02_1` LONGTEXT NULL,
    `pol_4_txt_tbl_02_1` TEXT NULL,
    `pol_5_int_tbl_02_1` INT(11) NULL DEFAULT NULL,
    PRIMARY KEY (`id_tbl_02_1`)
)
COLLATE='utf8_general_ci'
ENGINE=MyISAM
ROW_FORMAT=DYNAMIC
AUTO_INCREMENT=7
;

CREATE TABLE `trg` (
    `datetime_log` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `tbl_02_name_log` TEXT NULL,
    `id_tbl_02_n_log` INT(11) NULL DEFAULT NULL,
    `tbl_02_pol_name_log` TEXT NULL,
    `tbl_02_pol_content_log` TEXT NULL
)

COLLATE='utf8_general_ci'
ENGINE=MyISAM
ROW_FORMAT=DYNAMIC
;

CREATE DEFINER=`root`@`%` TRIGGER `trg_02_1_test_before_update` BEFORE UPDATE ON `trg_02_1_test` FOR EACH ROW BEGIN
/*РАБОТАЕТ ДАТА*/
  IF (NOT OLD.pol_1_date_tbl_02_1 <=> NEW.pol_1_date_tbl_02_1)
    THEN  
    INSERT INTO trg_02_00_log(tbl_02_tbl_name_log, id_tbl_02_n_log, tbl_02_pol_name_log, tbl_02_pol_content_log)  
    VALUES('trg_02_1_test', NEW.id_tbl_02_1, 'pol_1_date_tbl_02_1' ,NEW.pol_1_date_tbl_02_1);
  END IF;
 
      /*РАБОТАЕТ enum*/
  IF (NOT OLD.pol_2_enum_tbl_02_1 <=> NEW.pol_2_enum_tbl_02_1)
    THEN  
    INSERT INTO trg_02_00_log(tbl_02_tbl_name_log, id_tbl_02_n_log, tbl_02_pol_name_log, tbl_02_pol_content_log)  
    VALUES('trg_02_1_test', NEW.id_tbl_02_1, 'tbl_02_pol_name_log' ,NEW.pol_2_enum_tbl_02_1);
  END IF;
 
      /*РАБОТАЕТ longtxt*/
  IF (NOT OLD.pol_3_longtxt_tbl_02_1 <=> NEW.pol_3_longtxt_tbl_02_1)
    THEN  
    INSERT INTO trg_02_00_log(tbl_02_tbl_name_log, id_tbl_02_n_log, tbl_02_pol_name_log, tbl_02_pol_content_log)  
    VALUES('trg_02_1_test', NEW.id_tbl_02_1, 'pol_3_longtxt_tbl_02_1' ,NEW.pol_3_longtxt_tbl_02_1);
  END IF;

    /*РАБОТАЕТ ТЕКСТ*/
    IF (NOT OLD.pol_4_txt_tbl_02_1 <=> NEW.pol_4_txt_tbl_02_1)
    THEN  
    INSERT INTO trg_02_00_log(tbl_02_tbl_name_log, id_tbl_02_n_log, tbl_02_pol_name_log, tbl_02_pol_content_log)  
    VALUES('trg_02_1_test', NEW.id_tbl_02_1, 'pol_4_txt_tbl_02_1' ,NEW.pol_4_txt_tbl_02_1);
  END IF;

      /*РАБОТАЕТ int*/
  IF (NOT OLD.pol_5_int_tbl_02_1 <=> NEW.pol_5_int_tbl_02_1)
    THEN  
    INSERT INTO trg_02_00_log(tbl_02_tbl_name_log, id_tbl_02_n_log, tbl_02_pol_name_log, tbl_02_pol_content_log)  
    VALUES('trg_02_1_test', NEW.id_tbl_02_1, 'pol_5_int_tbl_02_1' ,NEW.pol_5_int_tbl_02_1);
  END IF;

END