Question

mysql insert触发器问题

怎样用mysql语句创建一个insert数据时的触发器，当我向user表里插入一条数据时，怎样让它触发project表里也插入一条数据，并且project表里插入的数据的username与project表里的username一样。如我用sql server 写的：

create trigger trig_user
on users
after insert
as
declare @dh varchar(30)
set @dh=(select username from inserted)
insert into project (username,teamname,pro_name)
values(@dh,@dh,@dh)

怎样在mysql里实现一样的功能？求指教？

Answer 1

CREATE TRIGGER testref AFTER INSERT ON users
FOR EACH ROW BEGIN declare @dh varchar(30) select NEW.username into @dh from NEW; insert into project (username,teamname,pro_name) values(@dh,@dh,@dh); END@dh 是插入username的值

Answer 2

类似如下：
CREATE TRIGGER `trig_user` AFTER UPDATE ON `users` FOR EACH ROW BEGIN
insert into project (username,teamname,pro_name) values (NEW.username,NEW.username,NEW.username);
END

Answer 3

楼上正解！！