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的值
类似如下：CREATE TRIGGER `trig_user` AFTER UPDATE ON `users` FOR EACH ROW BEGINinsert into project (username,teamname,pro_name) values (NEW.username,NEW.username,NEW.username);END
楼上正解！！