• <bdo id='TSJVW'></bdo><ul id='TSJVW'></ul>

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

    1. <i id='TSJVW'><tr id='TSJVW'><dt id='TSJVW'><q id='TSJVW'><span id='TSJVW'><b id='TSJVW'><form id='TSJVW'><ins id='TSJVW'></ins><ul id='TSJVW'></ul><sub id='TSJVW'></sub></form><legend id='TSJVW'></legend><bdo id='TSJVW'><pre id='TSJVW'><center id='TSJVW'></center></pre></bdo></b><th id='TSJVW'></th></span></q></dt></tr></i><div id='TSJVW'><tfoot id='TSJVW'></tfoot><dl id='TSJVW'><fieldset id='TSJVW'></fieldset></dl></div>
    2. <legend id='TSJVW'><style id='TSJVW'><dir id='TSJVW'><q id='TSJVW'></q></dir></style></legend>
      <tfoot id='TSJVW'></tfoot>
    3. 如何将参数传递给nodejs中的mysql查询回调

      时间:2023-06-01

        • <tfoot id='3k97e'></tfoot><legend id='3k97e'><style id='3k97e'><dir id='3k97e'><q id='3k97e'></q></dir></style></legend>
          1. <i id='3k97e'><tr id='3k97e'><dt id='3k97e'><q id='3k97e'><span id='3k97e'><b id='3k97e'><form id='3k97e'><ins id='3k97e'></ins><ul id='3k97e'></ul><sub id='3k97e'></sub></form><legend id='3k97e'></legend><bdo id='3k97e'><pre id='3k97e'><center id='3k97e'></center></pre></bdo></b><th id='3k97e'></th></span></q></dt></tr></i><div id='3k97e'><tfoot id='3k97e'></tfoot><dl id='3k97e'><fieldset id='3k97e'></fieldset></dl></div>
          2. <small id='3k97e'></small><noframes id='3k97e'>

              <tbody id='3k97e'></tbody>
            • <bdo id='3k97e'></bdo><ul id='3k97e'></ul>

                本文介绍了如何将参数传递给nodejs中的mysql查询回调的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!

                问题描述

                我正在尝试找出将自定义数据传递给要在回调中可用的查询调用的正确方法.我在 nodejs 中使用 MySQL 库(所有最新版本).

                I'm trying to figure out the correct way of passing custom data to a query call to be made available in the callback. I'm using MySQL library in nodejs (all latest versions).

                我打电话给 connection.query(sql, function(err, result) {...});

                I have a call to connection.query(sql, function(err, result) {...});

                我找不到一种方法来 1) 将自定义数据/参数传递给调用,以便 2) 在调用回调时可以使用它.那么这样做的正确方法是什么?

                I couldn't find a way to 1) pass custom data/parameter to the call so that 2) it can be made available when the callback is invoked. So what is the proper way of doing so?

                我有以下(伪代码):

                ...
                for (ix in SomeJSONArray) {
                    sql = "SELECT (1) FROM someTable WHERE someColumn = " + SomeJSONArray[ix].id;
                    connection.query(sql, function (err, result) {
                      ...
                      var y = SomeJSONArray[ix].id;
                    };
                }
                

                从上面的代码来看,我需要能够将查询中使用的ix"的当前值传递给回调本身.

                From the code above, I need to be able to pass the current value of "ix" used in the query to the callback itself.

                我该怎么做?

                推荐答案

                如果您使用的是 node-mysql,请按照文档中的说明进行操作:

                If you are using node-mysql, do it like the docs say:

                connection.query(
                    'SELECT * FROM table WHERE id=? LIMIT ?, 5',[ user_id, start ], 
                    function (err, results) {
                
                    }
                );
                

                文档也有正确转义字符串的代码,但在查询调用中使用数组会自动为您转义.

                The docs also have code for proper escaping of strings, but using the array in the query call automatically does the escaping for you.

                https://github.com/felixge/node-mysql

                这篇关于如何将参数传递给nodejs中的mysql查询回调的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

                上一篇:MySQL 中的 INSERT 和 UPDATE 有什么区别? 下一篇:Mysql 权限错误与“加载数据"

                相关文章

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

                  <small id='8wLXi'></small><noframes id='8wLXi'>

                    <legend id='8wLXi'><style id='8wLXi'><dir id='8wLXi'><q id='8wLXi'></q></dir></style></legend>
                  1. <tfoot id='8wLXi'></tfoot>