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??