Hello Friends,

I'm creating procedures as the code below but it's raising an problem.



DELIMITER $$
DROP PROCEDURE IF EXISTS `SP_Select` $$
CREATE PROCEDURE `SP_Select` (id int)
BEGIN
Select ID from Rough where ID=id
END $$

DELIMITER ;


Here is the error i'm getting shown below

Script line: 3 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'END' at line 3

Hi Manoj,

You need to add the ; to the end of the select statement, as you would with normal statements. At the moment it thinks the END is part of the select.
This is why the delimiter is set to $$ while you are defining the procedure, so it doesn't accidentally read the semicolons within it to be the end of the procedure.

Hope this helps
Phil