mysql> delimiter // mysql> create trigger upd_check before update on account -> for each row -> begin -> if new.amount < 0 then -> set new.amount=0; -> elseif new.amount > 100 then -> set new.amount = 100; -> end if; -> end; -> // Query OK, 0 rows affected (0.00 sec) mysql> delimiter ;
Mysql中delimiter作用,布布扣,bubuko.com
原文:http://blog.csdn.net/yonggang7/article/details/24558385