mysql触发器,编写错误
user表有4个字段,id,username,password,email,写触发器是实现插入
一条数据到user表中时同时触发插入到test表中,test表字段,类型和
user表一样,下面是我的代码,执行不过去,求大牛指正,谢谢
create trigger insertuser
on user
for insert
as
declare
@id as int;
@username as varchar(20);
@password as varchar(20);
@email as varchar(20);
select @id=(select id from inserted);
select @username=(select username from inserted) ;
select @password=(select password from inserted);
select @email=(select email from inserted);
insert into test (id,username,password,email) values (@id,@username,@password,@email)