1
Answer

Stored Procedure in MySql

Photo of Manoj Bisht

Manoj Bisht

16y
3k
1
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

Answers (1)

0
Photo of Suthish Nair
NA 31.7k 4.6m 12y
This might be a turning point for Windows phone and tablets... hoping for great innovations.