Question
What does DELIMITER // do in a Trigger?
DELIMITER //
What is the of use of it?
45 91106
45
Question
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.
Solution
In SQL you close each statement with a delimiter, which is by default a semicolon (;). In a trigger you need to write multiple statements, each ending in a semicolon. To tell MySQL that those semicolons are not the end of your trigger statement, you temporarily change the delimiter from ; to //, so MySQL will know that the trigger statement only ends when it econunters a //.