<small id='nzZRe'></small><noframes id='nzZRe'>

  • <i id='nzZRe'><tr id='nzZRe'><dt id='nzZRe'><q id='nzZRe'><span id='nzZRe'><b id='nzZRe'><form id='nzZRe'><ins id='nzZRe'></ins><ul id='nzZRe'></ul><sub id='nzZRe'></sub></form><legend id='nzZRe'></legend><bdo id='nzZRe'><pre id='nzZRe'><center id='nzZRe'></center></pre></bdo></b><th id='nzZRe'></th></span></q></dt></tr></i><div id='nzZRe'><tfoot id='nzZRe'></tfoot><dl id='nzZRe'><fieldset id='nzZRe'></fieldset></dl></div>

    <legend id='nzZRe'><style id='nzZRe'><dir id='nzZRe'><q id='nzZRe'></q></dir></style></legend>
        <tfoot id='nzZRe'></tfoot>
          <bdo id='nzZRe'></bdo><ul id='nzZRe'></ul>

        将 LIMIT 作为参数传递给 MySQL sproc

        时间:2023-06-03

      1. <i id='ZQRPW'><tr id='ZQRPW'><dt id='ZQRPW'><q id='ZQRPW'><span id='ZQRPW'><b id='ZQRPW'><form id='ZQRPW'><ins id='ZQRPW'></ins><ul id='ZQRPW'></ul><sub id='ZQRPW'></sub></form><legend id='ZQRPW'></legend><bdo id='ZQRPW'><pre id='ZQRPW'><center id='ZQRPW'></center></pre></bdo></b><th id='ZQRPW'></th></span></q></dt></tr></i><div id='ZQRPW'><tfoot id='ZQRPW'></tfoot><dl id='ZQRPW'><fieldset id='ZQRPW'></fieldset></dl></div>

          <tbody id='ZQRPW'></tbody>

      2. <small id='ZQRPW'></small><noframes id='ZQRPW'>

            <tfoot id='ZQRPW'></tfoot>
              <legend id='ZQRPW'><style id='ZQRPW'><dir id='ZQRPW'><q id='ZQRPW'></q></dir></style></legend>

                <bdo id='ZQRPW'></bdo><ul id='ZQRPW'></ul>
                1. 本文介绍了将 LIMIT 作为参数传递给 MySQL sproc的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!

                  问题描述

                  我正在创建一个分页类,需要将两个参数传递给我的 MySQL 存储过程以用于 LIMIT 子句.

                  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
                  

                  当我尝试保存 sproc 时,它给了我一个错误.有没有办法做到这一点,我只是想念?还是我必须对整个查询进行 EVAL 并执行它?

                  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 之前,LIMIT 无法在 MySQL 存储过程中参数化.您需要动态构建查询并执行它.

                  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 及更高版本中,您可以将存储的 procs 参数作为参数传递给 LIMITOFFSET,只要它们是 INTEGER>.

                  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的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

                  上一篇:MySQL浮点比较问题 下一篇:如何在 MySQL 中滞后列?

                  相关文章

                2. <small id='u1EIb'></small><noframes id='u1EIb'>

                  <legend id='u1EIb'><style id='u1EIb'><dir id='u1EIb'><q id='u1EIb'></q></dir></style></legend>

                  <i id='u1EIb'><tr id='u1EIb'><dt id='u1EIb'><q id='u1EIb'><span id='u1EIb'><b id='u1EIb'><form id='u1EIb'><ins id='u1EIb'></ins><ul id='u1EIb'></ul><sub id='u1EIb'></sub></form><legend id='u1EIb'></legend><bdo id='u1EIb'><pre id='u1EIb'><center id='u1EIb'></center></pre></bdo></b><th id='u1EIb'></th></span></q></dt></tr></i><div id='u1EIb'><tfoot id='u1EIb'></tfoot><dl id='u1EIb'><fieldset id='u1EIb'></fieldset></dl></div>

                      <tfoot id='u1EIb'></tfoot>
                        <bdo id='u1EIb'></bdo><ul id='u1EIb'></ul>