TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Manoj Bisht
NA
140
0
Stored Procedure in MySql
Feb 27 2009 7:08 AM
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
Reply
Answers (
1
)
Insert problem
one ore many sql tables