项目之Mysql中遇到的问题

MYSQL

1.问题1：建立触发器时候引发如下问题，原因是触发器对于分号过于敏感

create definer = root@localhost trigger avatar
    after insert
    on user
    for each row
begin
    insert into user_avatar (Avatar_id, Username)
    values (new.id, new.Username);
end;

报错提示如下：

create definer = root@localhost trigger avatar     after insert     on user     for each row begin     insert into user_avatar (Avatar_id, Username)     values (new.id, new.Username)	
Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 7	0.000 sec

改正结果如下：
方法1————删除begin end两行

create definer = root@localhost trigger avatar
    after insert
    on user
    for each row
      insert into user_avatar (Avatar_id, Username)
      values (new.id, new.Username);

方法二————上下添加如下

delimiter |
create definer = root@localhost trigger avatar
    after insert
    on user
    for each row
begin
    insert into user_avatar (Avatar_id, Username)
    values (new.id, new.Username);
end;
|
delimiter ;