0

**
Hello i am newbiw to MYSQL .... iwant to create stored procedure in PHPMYADMIN . But when i am same procedue od MS SQL in MYSQL it 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)

begin
select Company_Name from companynames
where ' at line 2

this is my MS SQL Stored Procedure
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
create procedure spGetCompanyNames
@CompanyNams varchar(250)
begin
select Company_Name from companynames
where Company_Name Like @CompanyNams + '%'
end


Plz Help

**

2
Contributors
1
Reply
11
Views
3 Years
Discussion Span
Last Post by AleMonteiro
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.