Saturday, 6 October 2012

What is DELIMITER //


Hi,
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.
source: stackoverflow.com

No comments:

Post a Comment