javascript - 代码 : "ER_PARSE_ERROR", errno : 1064, mySQL

Question

尝试基于一种形式插入多个插入时出现以下错误

"sql: "INSERT INTO ( pokemon (pokemonname) VALUES ('sadfasd'), INSERT INTO location (locationname) VALUES ('asdfasdf'), INSERT INTO primarymove (primarymovename) VALUES ('asdf'), 插入类型(typename) VALUES ('2'))"

sqlMessage: "你的 SQL 语法有错误；检查对应于你的 MariaDB 服务器版本的手册，了解在 '( pokemon (pokemonname) VALUES ('sadfasd'), INSERT INTO location (locationname ) ' 在第 1 行","

下面是我的发帖请求

   router.post('/', function(req, res){
    var mysql = req.app.get('mysql');
    var sql = "INSERT INTO pokemon (pokemonname) VALUES (?), INSERT INTO location (locationname) VALUES (?), INSERT INTO primarymove (primarymovename) VALUES (?), INSERT INTO type (typename) VALUES (?)";
    var inserts = [req.body.pokemonname, req.body.locationname, req.body.primarymovename, req.body.typename];
    sql = mysql.pool.query(sql, inserts, function(error, results, fields){
            if(error){
                    res.write(JSON.stringify(error));
                    res.end();
            } else{
                    res.redirect('/pokemon');
             }
    });

});

我假设它与我的多个 INSERT INTO 请求有关，我基本上是在尝试对各种不同的表执行多个插入语句。还是不可能？

Answer 1

你需要用';'替换逗号