Search code examples
sqlmysqldatabasetriggersdelimiter

What does DELIMITER // do in a Trigger?

DELIMITER //

What is the of use of it?

Solution

  • 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.