数据库触发器(Mysql&&SQLserver)

Create TABLE `area` (
  `area_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  `area_nm` char(16) NOT NULL DEFAULT '',
  `area_idx` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `show_ord` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`area_id`),
  KEY `area_idx` (`area_idx`),
  KEY `show_ord` (`show_ord`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

Create TRIGGER `area_after_upd_tr` AFTER Update ON `area`
  FOR EACH ROW
BEGIN
     IF OLD.area_nm!=NEW.area_nm THEN
        Insert INTO area_1(area_id,area_nm,area_idx,show_ord)
               Select area_id,NEW.area_nm,area_idx,show_ord FROM
                      area Where area_id=OLD.area_id;
     END IF;
END;

Create TABLE `area_1` (
  `area_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  `area_nm` char(16) NOT NULL DEFAULT '',
  `area_idx` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `show_ord` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`area_id`),
  KEY `area_idx` (`area_idx`),
  KEY `show_ord` (`show_ord`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

Create TRIGGER trigger_name
ON { table | view }
[ WITH ENCRYPTION ]
{
    { {FOR | AFTER | INSTEAD OF } { [ Insert ] [ , ] [ Update ] [ , ] [ Delete ] }
        [ WITH APPEND ]
        [ NOT FOR REPLICATION ]
        AS
        [ { IF Update ( column )
            [ { AND | or } Update ( column ) ]
                [ ...n ]
        | IF ( COLUMNS_UpdateD ( ) { bitwise_operator } updated_bitmask )
                { comparison_operator } column_bitmask [ ...n ]
        } ]
        sql_statement [...n ]
    }
}