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, 意思是缺少分号...
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, 意思是缺少分号...