passing LIMIT as parameters to MySQL sproc

Posted by Kyle on Stack Overflow See other posts from Stack Overflow or by Kyle
Published on 2010-05-20T15:28:18Z Indexed on 2010/05/20 15:30 UTC
Read the original article Hit count: 186

Filed under:

mysql-stored-procedure

|

limit-clause

I'm creating a paging class and need to pass in two parameters to my MySQL stored procedure for the LIMIT clause.

I'm passing them in as INTs and trying something like this

SELECT *
FROM
`MyTable`
LIMIT
MyFirstParamInt, MySecondParamInt

it gives me an error when I try and save the sproc though. Is there a way to do this that I'm just missing? Or am I going to have to EVAL the whole query and EXECUTE it?

© Stack Overflow or respective owner

Related posts about mysql-stored-procedure

Perl DBI execute not maintaining MySQL stored procedure results

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm having a problem with executing a stored procedure from Perl (using the DBI Module). If I execute a simple SELECT * FROM table there are no problems. The SQL code is: DROP FUNCTION IF EXISTS update_current_stock_price; DELIMITER | CREATE FUNCTION update_current_stock_price (symbolIN VARCHAR(20)… >>> More
Passing object from PHP to Mysql Stored procedure

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi All, Scenario :- I have to call MYSQL stored procedure from PHP and do some operations ( around 15 commands ) on the database Problem :- I have to call stored procedure with 36 parameters. Lot of parameters . I don't think it is a good idea to pass these many individual parameters and even heard… >>> More
Selecting multiple fields into multiple variables in a MySQL stored procedure

as seen on Stack Overflow - Search for 'Stack Overflow'
I am a little new to store procedures in MySQL and was wondering if I can SELECT multiple columns into multiple variables within the same select query. for example (iName is the input to the function): DECLARE iId INT(20); DECLARE dCreate DATETIME; SELECT Id INTO iId, dateCreated INTO dCreate… >>> More
use result set of mysql stored procedure in another stored procedure

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a MYSQL stored procedure SP1() that returns a result set. I want to call SP1() inside of SP2() and loop through the result set of SP1() to do some additional work. I don't want to include my logic from SP1() because it would make SP2() too complicated. Any suggestions? Thanks. >>> More
Generating a text file in MYSQL stored procedure

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I'm new to MySQL, I am trying to create a text file using a stored procedure. I'm currently at the stage where I have a temporary table that contains all of the records that I want to output to a text file. I have the following line at the end of my SP, it works in PHPMYAdmin's query but it… >>> More

Related posts about limit-clause

MYSQL and the LIMIT clause

as seen on Stack Overflow - Search for 'Stack Overflow'
I was wondering if adding a LIMIT 1 to a query would speed up the processing? For example... I have a query that will most of the time return 1 result, but will occasionaly return 10's, 100's or even 1000's of records. But I will only ever want the first record. Would the limit 1 speed things up… >>> More
php paging and the use of limit clause

as seen on Stack Overflow - Search for 'Stack Overflow'
Imagine you got a 1m record table and you want to limit the search results down to say 10,000 and not more than that. So what do I use for that? Well, the answer is use the limit clause. example select recid from mytable order by recid asc limit 10000 This is going to give me the last 10,000 records… >>> More
mySQL: Can I make count() honor limit clause?

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to get a count of records matching certain criteria within a subset of the total records. I tried (and assumed this would work) SELECT count(*) FROM records WHERE status = 'ADP' LIMIT 0,10 and I assumed this would tell me how many records of status ADP were in that set of 10 records… >>> More
passing LIMIT as parameters to MySQL sproc

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm creating a paging class and need to pass in two parameters to my MySQL stored procedure for the LIMIT clause. I'm passing them in as INTs and trying something like this SELECT * FROM `MyTable` LIMIT MyFirstParamInt, MySecondParamInt it gives me an error when I try and save the sproc though… >>> More
Performance Enhancement in Full-Text Search Query

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Ever since its first release, we are continuing consolidating and developing InnoDB Full-Text Search feature. There is one recent improvement that worth blogging about. It is an effort with MySQL Optimizer team that simplifies some common queries’ Query Plans and dramatically shorted the query… >>> More