I have written a stored procedure in SQLYog in MySQL as follows,
DELIMITER $$
DROP PROCEDURE IF EXISTS
test
.spUser
$$CREATE PROCEDURE
test
.spUser
(IN start1 INT,IN limit1 INT)BEGIN
select gi.id,gi.user_id,concat(concat(first_name,' '),last_name) as full_name from generic as gi, profile as p where gi.user_id=p.user_id limit start1,limit1;
END$$
DELIMITER ;
If I have written above code then it throws error no. 1064 and if I have replaced limit start1,limit1 by limit 5,10 then it run properly.
How can I resolve this problem?