Stored Procedure in MySql

Question

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