DELIMITER $$
USE `test1`$$
DROP TRIGGER /*!50032 IF EXISTS */ `tr_insert`$$
CREATE
/*!50017 DEFINER = 'root'@'%' */
TRIGGER `tr_insert` BEFORE INSERT ON `new`
FOR EACH ROW
BEGIN
IF new.a>new.b THEN
SET new.c='是';
ELSEIF new.a<new.b THEN
SET new.d='是';
END IF;
END;
$$
DELIMITER ;