DROP TRIGGER if EXISTS a_insert;
create trigger a_insert
after insert on a
for each row
BEGIN
IF (select count(*) from urlanddate b where b.url=new.robberHost and b.date=new.date)=0 THEN
insert into urlanddate (`url`,`date`) values (new.robberHost,new.date);
END IF;
END;
###表结构a(id,robberUrl,date,.....)
###表结构urlanddate(id,url,date)
create trigger a_insert
after insert on a
for each row
BEGIN
IF (select count(*) from urlanddate b where b.url=new.robberHost and b.date=new.date)=0 THEN
insert into urlanddate (`url`,`date`) values (new.robberHost,new.date);
END IF;
END;
###表结构a(id,robberUrl,date,.....)
###表结构urlanddate(id,url,date)