网站建设资讯

NEWS

网站建设资讯

加个trigger

DELIMITER |
CREATE TRIGGER phpmyadmin.tri_hisInsert AFTER INSERT
ON pma__history FOR EACH ROW
BEGIN
  INSERT INTO user_act_history (`username`,`db`,`table`,`timevalue`,`sqlquery`) VALUES (NEW.`username`,NEW.`db`,NEW.`table`,NEW.`timevalue`,NEW.`sqlquery`);
END|
DELIMITER ;

文章名称:加个trigger
网站路径:http://cdweb.net/article/jhdjoh.html