mysql delimiter 作用

mysql 遇到;就执行，有时候为了写存储过程，所以重新定义delimiter,以便于写更多的语句，自己控制mysql何时执行.

例如

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;//
mysql> delimiter ;

 

转载于:https://my.oschina.net/liangzhenghui/blog/841636