USE `mydatabase`;

DELIMITER $$

CREATE DEFINER=`root`@`localhost` TRIGGER `SAMPLETIGGER`
AFTER INSERT ON `temptrigger`
FOR EACH ROW
BEGIN
  DELETE FROM TEMPTRIGGER where TEMPTRIGGER.Col1=TEMPTRIGGER.Col2;
END$$

DELIMITER ;