What does DELIMITER // do in a Trigger?

DELIMITER //

What is the of use of it?

Answer

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.