Mysql的delimiter

需要事先把delimiter换成其它符号，如//或$$。 

DELIMITER $$   
DROP TRIGGER IF EXISTS `updateegopriceondelete`$$   
CREATE   
    TRIGGER `updateegopriceondelete` AFTER  DELETE ON  `customerinfo`   
    FOR EACH ROW BEGIN   
DELETE FROM egoprice  WHERE customerId=OLD.customerId;   
    END$$   
DELIMITER ;

　　DELIMITER 定好结束符为"$$", 然后最后又定义为";", MYSQL的默认结束符为";".!!!!! 

Mysql的delimiter

标签：mit   span   情况   其它   price   tle   limit   客户   命令行