Mysql 中如何创建触发器

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28

use websitelogdb; #创建表 CREATE TABLE `test` (   `idtest` int(11) NOT NULL AUTO_INCREMENT,   `testcol` varchar(45) DEFAULT NULL,   `testcol1` varchar(45) DEFAULT NULL,   PRIMARY KEY (`idtest`) ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;     SELECT * FROM websitelogdb.test;     set @id = 'mysql'; #创建Trigger DROP TRIGGER IF EXISTS t_afterinsert_on_test; delimiter | CREATE TRIGGER t_afterinsert_on_test AFTER INSERT ON websitelogdb.test FOR EACH ROW BEGIN     set @id = new.idtest; END; | delimiter ;   #调用Trigger触发器 insert into websitelogdb.test(testcol, testcol1) values('1','1'); select @id;