problem in creating stored procedure

Question

1.00/5 (1 vote)

See more:

, +

Hello i am newbie to MYSQL Database .... i want to create stored procedure in MYSQL .. I have written the same procedure in MSSQL and it was running but when i am running it in PHPMYADMIN(MYSQL) its is giving error:

1064 - 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 '@'companyna' nvarchar(150)<br />
begin<br />
select Company_Name from companynames<br />
where ' at line 2

this is my MS SQL Stored Procedure

SQL

create proc spgetcompanynames
@companyna nvarchar(150)
as
begin
select Company_Name from companynames
where Company_Name Like @companyna + '%'
end

this is my MYSQL Stored Procedure

SQL

create procedure spGetCompanyNames @CompanyNams varchar(250) begin select Company_Name from companynames where Company_Name Like @CompanyNams + '%' end

Plz Help me in finding the error .

Posted 3-Aug-14 1:48am

himanshuchawla4393

Updated 3-Aug-14 2:00am

Abhishek Pant

v2

Add a Solution

Comments

Abhishek Pant 3-Aug-14 8:47am

MySQL Stored Procedure Parameters[^]

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)

Gupta Poonam · Answer 1 · 2014-08-11T03:49:00

Solution 3

try this....

SQL

Create procedure spGetComapnyNames(IN companyname varchar(150))
BEGIN
select Company_Name from companynames
where Company_Name Like companyname + '%'
END

Posted 11-Aug-14 3:49am

Gupta Poonam

OriginalGriff · Answer 2 · 2014-08-03T02:50:00

Solution 1

Close!
Try:

SQL

create procedure spGetCompanyNames
(@CompanyNams varchar(250))
begin
select Company_Name from companynames
where Company_Name Like @CompanyNams + '%'
end

Posted 3-Aug-14 2:50am

OriginalGriff

Comments

himanshuchawla4393 3-Aug-14 13:58pm

Its not Working .... Still there is error !!

vbhvshetty · Answer 3 · 2014-08-09T21:21:00

create proc spgetcompanynames
@companyna nvarchar(150)
as
begin
select Company_Name from companynames
where Company_Name Like @companyna + '%'
end

In above query please change table name to Column Name(Company_Name is table name in Where clause).
Write column name in which you want to perform search in where clause.

SQL

create proc spgetcompanynames
@companyna nvarchar(150)
as
begin
select Company_Name from companynames
where COLUMNAME  Like @companyna + &#39;%&#39;
end