mysql_old_wrong

DELIMITER $
create trigger auto_post_person_point
after insert on post for each row
begin
update person set point = point+10 where person_id = new.person_id;
end$

DELIMITER $... ...$ 这个不写会报错:missing semicolon, 意思是缺少分号...

转载于:https://www.cnblogs.com/chinashenkai/p/9451388.html