Link to home
Start Free TrialLog in
Avatar of kingjely
kingjelyFlag for Australia

asked on

Mysql stored Procedure DELIMITER // DELIMITER $$

what is the difference between


DELIMITER //
and
DELIMITER $$
ASKER CERTIFIED SOLUTION
Avatar of Muhammad Khan
Muhammad Khan
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of kingjely

ASKER

as stupid as it sounds, Not sure i understand fully.

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.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial

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.
Ahh Okay thanks pare !