Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 server issue

Author  Topic 

goria
Starting Member

1 Post

Posted - 2012-11-10 : 12:13:23
i am uploading an application on server using cpanel.
but the problem i am getting is as i am using Mysql 5.6
but on cpanel the version is 5.1.
like i am using procedure as

create procedure usp_select_data(in c1 int,in c2 int)
begin
select * from candidate
limit c1 offset c2
end

its not working..
but if i do as
create procedure usp_select_data(in c1 int,in c2 int)


begin
select * from candidate
limit 6 offset 2
end

the error i am getting is #1064

is this version issue or any other problaem??
what should i do??

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-11-10 : 12:17:35
You've posted your question on a Microsoft SQL Server site. You should post your question on a site that deals with MySql instead.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -