What does DELIMITER // do in a Trigger?


What is the of use of it?


  • It changes the statement delimiter from ; to //. This is so you can write ; in your trigger definition without the MySQL client misinterpreting that as meaning you're done with it.

    Note that when changing back, it's DELIMITER ;, not DELIMITER; as I've seen people try to do.