如何使用node js在数组中插入sql查询数据

Question

如何使用node js在数组中插入sql查询数据
我想在mysql数据库中插入数据，也在使用node js的数组中请给予适当的解决办法。

var conn = mysql.createConnection({
host: "localhost",
user: "root",
password: "root@123",
database: "abc"
});
conn.connect(function(err) {
if (err) throw err;
console.log("Connected!");
});
var temp = [1, 2];
sql =
"INSERT INTO  student(`name`, `email`) VALUES (?) ";
conn.query(sql, [temp], function (err, result) {
console.log(temp);
if (err) throw err;
conn.end();
});```

Answer 1

嘿，请像这样修改你的代码…

var conn = mysql.createConnection({
host: "localhost",
user: "root",
password: "root@123",
database: "abc"
});
conn.connect(function(err) {
if (err) throw err;
console.log("Connected!");
});
var temp = [1, 2];
var sql =
"INSERT INTO  student(`name`, `email`) VALUES (?,?) ";
conn.query(sql, temp, function (err, result) {
console.log(temp);
if (err) throw err;
conn.end();
});