DROP TRIGGER IF EXISTS `db01`.`tg_01`;
CREATE TRIGGER `db01`.`tg_01`
BEFORE INSERT ON db01.tb02
FOR EACH ROW
begin
/**trigger body**/
set new.createTime = (SELECT `gmt_create` FROM `tb01` WHERE `id` = new.id);
end;
db01: 数据库名
tg_01: 触发器名称
tb02: 触发表
END。