BEGIN		IF (select new.name NOT REGEXP (SELECT IF((select filterword from t_crawl_configuration where id=new.crawl_id)='','fzuir',(select filterword from t_crawl_configuration where id=new.crawl_id))) and new.price>=(select lowest_price from t_crawl_configuration where id=new.crawl_id))  then						insert into t_product_data(crawl_url_id,pid,name,price,crawl_id) values(new.crawl_url_id,new.pid,new.name,new.price,new.crawl_id);		end if;END

插入表格过程中建立触发器

-- 触发器 同时插入有用数据

DROP TRIGGER IF EXISTS t_afterinsert_on_t_product;

CREATE TRIGGER t_afterinsert_on_t_product

AFTER INSERT ON t_product

FOR EACH ROW

BEGIN

IF (select new.name NOT REGEXP (SELECT IF((select filterword from t_crawl_configuration where id=new.crawl_id)='','fzuir',(select filterword from t_crawl_configuration where id=new.crawl_id))) and new.price>=(select lowest_price from t_crawl_configuration where id=new.crawl_id)) then

insert into t_product_data(crawl_url_id,pid,name,price,crawl_id) values(new.crawl_url_id,new.pid,new.name,new.price,new.crawl_id);

end if;

END;

-- 触发器 同时插入有用数据

DROP TRIGGER IF EXISTS t_afterinsert_on_t_product_test;

CREATE TRIGGER t_afterinsert_on_t_product_test

AFTER INSERT ON t_product_test

FOR EACH ROW

BEGIN

IF (select new.name NOT REGEXP (SELECT IF((select filterword from t_crawl_configuration where id=new.crawl_id)='','fzuir',(select filterword from t_crawl_configuration where id=new.crawl_id))) and new.price>=(select lowest_price from t_crawl_configuration where id=new.crawl_id)) then

insert into t_product_data(crawl_url_id,pid,name,price,crawl_id) values(new.crawl_url_id,new.pid,new.name,new.price,new.crawl_id);

end if;

END;