kingjely
asked on
Mysql stored Procedure DELIMITER // DELIMITER $$
what is the difference between
DELIMITER //
and
DELIMITER $$
DELIMITER //
and
DELIMITER $$
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Okay, thanks guys !
There is no difference between // or $$. You can even use your own delimiter like %% or ## or any text sequence.
Default delimiter is ;
Mysql uses this to identify that query or procedure or any sql command has been ended.
Default delimiter is ;
Mysql uses this to identify that query or procedure or any sql command has been ended.
ASKER
Ahh Okay thanks pare !
ASKER
i can use either DELIMITER // OR DELIMITER $$
they are the same thing
I only use these at the start and end of a stored procedure to allow multiple semi colins ;
Is that correct.