sql - What does DELIMITER // do in a Trigger?

Question

DELIMITER //

What is the of use of it?

question from:https://stackoverflow.com/questions/1346637/what-does-delimiter-do-in-a-trigger

Answer 1

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.