将LIMIT作为参数传递给MySQL sproc [英] passing LIMIT as parameters to MySQL sproc

问题描述

我正在创建一个分页类，需要为LIMIT子句传递两个参数到我的MySQL存储过程中.

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

我将它们作为INT传递，并尝试这样的操作

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?

推荐答案

在5.5.6之前，无法在MySQL存储过程中对LIMIT进行参数化.您需要动态构建查询并执行它.

Prior to 5.5.6, LIMIT could not be parameterized in MySQL stored procedures. You'd need to build the query dynamically and execute it.

在5.5.6及更高版本中，只要它们是INTEGER，就可以将存储的procs参数作为参数传递给LIMIT和OFFSET.

In 5.5.6 and above, you can just pass the stored procs parameters as arguments to LIMIT and OFFSET as long as they are INTEGER.

这篇关于将LIMIT作为参数传递给MySQL sproc的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！