javascript - 需要帮助将多行推送到 MySQL

Question

我正在尝试将数据从一个文件推送到另一个文件中以构建 MySQL 查询。下面的代码是我所在的位置。我对 MySQL 有点迷茫和陌生，所以任何帮助都会很棒。总体思路是同时向表中插入两条记录。

预先感谢您的帮助。

INSERT INTO heroes (plantTypes, asset, cost, energy, isSunProducer, isShooter, isExploding,
 sunFrequency, shootingFrequency, damage, userId) 
VALUES (?,?,?,?,?,?,?,?,?,?,?), (?,?,?,?,
?,?,?,?,?,?,?)

INSERT INTO enemies (zombieTypes, asset, damage, vx, energy, userId) 
VALUES (?,?,?,?,?,?)

C:\Users\Jason\Desktop\RCB_Classwork\ProjectX\AyCarambaZombiesRising\node_modules\mysql\lib \protocol\Parser.js:78 throw err; // Rethrow non-MySQL errors

Error: ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?,?,?,?,?,?,?,?,?,?,?)' at line 1

        projectX.createNewUserHeroes(['plantTypes', 'asset', 'cost', 'energy', 'isSunProducer', 'isShooter', 'isExploding', 'sunFrequency', 'shootingFrequency', 'damage', 'userId'], ['shooterOne', 'test', 100, 100, 0, 1, 0, 0, 2, 100, req.session.user_id], ['shooterTwo', 'test', 100, 100, 0, 1, 0, 0, 2, 100, req.session.user_id], function(data){

            console.log("This is the right heroes data: " + data)   
        });

        createNewUserHeroes: function(table, cols, vals, cb) {
              var queryString = 'INSERT INTO ' + table;
              queryString += ' (plantTypes, asset, cost, energy, isSunProducer, isShooter, isExploding, sunFrequency, shootingFrequency, damage, userId) ';
              queryString += 'VALUES';
              queryString += ' (';
              queryString = queryString + printQuestionMarks(vals.length);
              queryString += ')';
              queryString += ', ';
              queryString += '(';
              queryString = queryString + printQuestionMarks(vals.length);
              queryString += ') ';

              console.log(queryString)

              connection.query(queryString, vals, function(err, result) {
                if (err) throw err;
                cb(result);
              });
            },

Answer 1

由于您要将准备好的查询中问号的数量加倍，因此您也需要将值数组加倍。您可以通过将 vals 连接到自身来完成此操作:

connection.query(queryString, vals.concat(vals), function(err, result) {
    ...
});