mysql 触发器问题

Question

DROP TRIGGER IF EXISTS t_afterinsert_on_tab1;
CREATE TRIGGER t_afterinsert_on_tab1 
AFTER INSERT ON tab1
FOR EACH ROW
BEGIN
     insert into tab2(tab2_id) values(new.tab1_id);
END;

报错

you have an error in your sql syntax; check the manual that correspinds to your mysql server version for the right syntax to use near "end" at line 1

Answer 1

这样呢？

DELIMITER $$
CREATE TRIGGER t_afterinsert_on_tab1 
AFTER INSERT ON tab1
FOR EACH ROW
BEGIN
     insert into tab2(tab2_id) values(new.tab1_id);
END $$

DELIMITER ;

更正：

END后应该有分号

Answer 2

自己问答
CREATE TRIGGER t_afterinsert_on_tab1
AFTER INSERT ON tab1
FOR EACH ROW
insert into tab2(tab2_id) values(new.tab1_id);

这样也可以