Jump to content

Stored procedure problem


vinoindiamca

Recommended Posts

Hi i got error in my mysql stored procedures

 

CREATE PROCEDURE getbooknew(IN names varchar(100),IN sets int(10),IN rows int(10))

begin

select * from booking where Name Like names ORDER BY bdate DESC LIMIT sets,rows;

end

 

sets and rows is for limit the records . I need to fetch records by using this query please help in this.

 

Link to comment
https://forums.phpfreaks.com/topic/143725-stored-procedure-problem/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.