使用mysql2运行大型INSERT查询时出现异常

Question

我使用mysql2包对MySQL服务器运行查询

以下是连接设置

getConnection: function () {


   let host = "hostname.com";
   let database = "database_name";
   let username = "username";
   let password = "pwd";


   let con = mysql.createConnection({
      host: host,
      user: username,
      password: password,
      database: database,
      connectTimeout: 15000
   });

   return con;
},

它适用于所有查询，只有insert查询有26个参数：

    recordCreate: function (con, param1, param2,
       param3,  param4,  param5,  param6,  param7,
       param8,  param9,  param10, param11, param12,
       param13, param14, param15, param16, param17,
       param18, param19, param20, param21, param22,
       param23, param24, param25, param26, callback) {
       try {
         con.connect(function (err, result) {
                 try {
                      if (err) throw err;
                      con.query(“INSERT INTO tbldata (param1,
                           param2,  param3,  param4,  param5,  param6,
                           param7,  param8,  param9,  param10, param11,
                           param12, param13, param14, param15, param16,
                           param17, param18, param19, param20, param21,
                           param22, param23, param24, param25, param26
                   ) VALUES 
                   (?, ?, ?, ?, ?,
                    ?, ?, ?, ?, ?,
                    ?, ?, ?, ?, ?,
                    ?, ?, ?, ?, ?,
                    ?, ?, ?, ?, ?,
                    ?)”,[param1,  param2,  param3,  param4,  param5,
                         param6,  param7,  param8,  param9,  param10,
                         param11, param12, param13, param14, param15,
                         param16, param17, param18, param19, param20,
                         param21, param22, param23, param24, param25,
                         param26]
       , function (err) {
          try {
             if (err) throw err;
             callback(true);
          } catch (err) {
             callback(err);
          } finally {
             con.close();
          }
  });

我一直收到以下错误消息：

C:\myprojects\tms\node_modules\mysql2\lib\commands\commands.js:30 this.onresult（err）；^

TypeError：this.onresult不是Connection.Query.Execute(C:\myProjects\tms\node_module\mysql2\lib\commands\commandd.js:30:14)处的函数。HandlePacket(C:\myProjects\tms\node_module\mysql2\lib\connection.js:449:32)处的PacketParser.Connection.PacketParser.p[as

进程已完成，退出代码为%1

声明那些数据元素（参数）确实很小是很重要的。我们在这里讨论了简短的10个字符、字符串和数字

例如：

INSERT INTO tbldata (param1,  param2,  param3,  param4,  param5,
                     param6,  param7,  param8,  param9,  param10,
                     param11, param12, param13, param14, param15,
                     param16, param17, param18, param19, param20,
                     param21, param22, param23, param24, param25,
                     param26) VALUES 
                    (51, 'Test 51', '', '2019-12-01', '2019-12-01',
                      1, 1, 1, 3, 3, 1, 1, 0, 0, 0, 0, 0, 1, 1, 0, 
                      0, 1, 1, 1, 3, 3);

我尝试在MySQL服务器上运行示例查询，它运行良好

Answer 1

在缩小查询范围之后，我意识到这是一个愚蠢的语法问题。我要感谢Nico Haase和Martin对我的“头脑风暴”的帮助。

我赞赏mysql2团队的工作。我还希望他们能够通过query方法获得2个以上的参数来解决这个问题。

con.query("INSERT INTO tbldata (" +
                                "param1, " +
                                "param2, " +
                                "param3, " +
                                "param4, ", -- here is the syntax issue. Comma instead of plus
                                "param5) VALUES (?, ?, " +
                                "?, ?, " +
                                "?, ?, " +
                                "?)",
                                [param1,
                                    param2,
                                    param3,
                                    param4,
                                    param5]