Posted
Filed under Htm&Javascript

delimiter $$
create trigger update_check BEFORE UPDATE on tb_list FOR EACH ROW
BEGIN
 
 IF NEW.tname <> OLD.tname THEN
           SET NEW.tname = OLD.tname;
 END IF;
END$$

delimiter ;

2015/03/31 23:08 2015/03/31 23:08