Create Procdeure in MY-SQL

Question

0.00/5 (No votes)

See more:

Hello friends,

Can any one tell me how to create procedure in MYSQL, I did in MS-SOL but that's not working.
//QUERY

SQL

create procedure sp_inc
(
 @Emp_ID int
)
AS
BEGIN
Select Emp_ID,Emp_name,Emp_sal AS Salary from Employee_test where Emp_ID = @Emp_ID;
END

Posted 29-Mar-13 1:24am

Neetesh Agarwal

Updated 29-Mar-13 1:28am

v2

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dnyaneshwar Kondbale · Accepted Answer · 2013-03-29T01:43:00

Solution 2

Try this

CREATE PROCEDURE sp_inc(Emp_ID INT)     
     BEGIN 
      Select Emp_ID,Emp_name,Emp_sal AS Salary from Employee_test where Emp_ID =Emp_ID;

     END $$

Posted 29-Mar-13 1:43am

Dnyaneshwar Kondbale

v2

Comments

Neetesh Agarwal 29-Mar-13 7:57am

Thanks bro,
But Its change in differenet version that's why I got error.

Neetesh Agarwal 29-Mar-13 8:23am

DELIMITER $$
CREATE PROCEDURE sp_inc(Emp_ID INT)
BEGIN
Select Emp_ID,Emp_name,Emp_sal AS Salary from Employee_test where Emp_ID = Emp_ID;
END

Thomas Daniels · Accepted Answer · 2013-03-29T01:36:00

Solution 1

Hi,

Have a look here:
An Introduction to Stored Procedures in MySQL 5[^]

Posted 29-Mar-13 1:36am

Thomas Daniels

Comments

Neetesh Agarwal 29-Mar-13 7:57am

http://dev.mysql.com/doc/refman/5.1/en/create-procedure.html

Neetesh Agarwal · Accepted Answer · 2013-03-29T02:26:00

Solution 3

//code

SQL

DELIMITER $$
   CREATE PROCEDURE sp_inc(Emp_ID INT)
 BEGIN
   Select Emp_ID,Emp_name,Emp_sal AS Salary from Employee_test where Emp_ID = Emp_ID;
 END

Posted 29-Mar-13 2:26am

Neetesh Agarwal

Updated 29-Mar-13 2:27am

v2