MySQL Forums
Forum List  »  Stored Procedures

Re: why DELIMITER $$
Posted by: Peter Larb
Date: December 15, 2005 03:21PM

From Andrew - much better answer - Thankyou

Hi Peter,

No you don't need to use //, the only requirement is that you use something other than the normal SQL delimiter which is ; therefore $$ is fine.

The reason // has been used so much is that is what was used in the original MySQL documentation which was released over a year ago when MySQL 5.0 was very much in it's infancy.

The general rule is to use something which isn't going to affect the code or be interpreted by MySQL as something else. From the command line // does the trick but $$ works just as well, I've also seen @@ and && used.

Regards

Andrew.

Peter Larb

Options: ReplyQuote


Subject
Views
Written By
Posted
2766
December 14, 2005 06:28AM
1635
December 15, 2005 04:10AM
Re: why DELIMITER $$
1405
December 15, 2005 03:21PM
1589
December 15, 2005 04:38PM
1539
December 27, 2005 02:58AM
1648
December 27, 2005 03:35AM
1531
December 27, 2005 04:06AM
1455
December 27, 2005 01:15PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.