Question

MySQL创建触发器一直报语法错误（急急急！！！！）

建了个触发器就是用户表新增一个用户之后，再另一个表的username字段插入用户名create trigger cre_favorites after insert on _user for each row begindeclare @username varchar(20);select @username=UserName from inserted;insert into favorites(UserName)values(@username);end;但是一直出现语法错误，网上说的什么去分号和加分号之类的也试过了，一直也是有错，求指点

Answer 1

CRREATE TRIGGER itop_physical_insert after insert on
itop_info.ipinterface
for each row
BEGIN
insert into itop_info.ipinterface_test(interfaceid,interfacename,devicename,ip)
values('100','test','test','1.1.1.1');
END;

Answer 2

同样的错误，求答！