插入时拼接两个字段的值插入到另一个字段
DROP TRIGGER IF EXISTS `tig_pinjie`;
CREATE TRIGGER `tig_pinjie`
BEFORE INSERT ON tab1
FOR EACH ROW
begin
/**trigger body**/
set new.c = concat(new.a ,b);
end;
事件: INSERT
触发时机: BEFORE
END。
DROP TRIGGER IF EXISTS `tig_pinjie`;
CREATE TRIGGER `tig_pinjie`
BEFORE INSERT ON tab1
FOR EACH ROW
begin
/**trigger body**/
set new.c = concat(new.a ,b);
end;
事件: INSERT
触发时机: BEFORE
END。