Node-mysql插入带有两个值的查询？ [英] Node-mysql insert query with two values?

问题描述

这是我目前的javascript。

This is my current javascript.

var connection = mysql.createConnection({
   host: 'localhost',
   user: 'root',
   password: 'root',
   database: 'codify',
   port:     '8889'     
})


connection.connect();
 //var querydata = +"'"+data.RegUsername + "','"+data.RegPassword+"'" 
  connection.query("INSERT INTO Codify (UsernameDB , PasswordDB) VALUES ?", data.RegUsername,+","+ data.Regpassword , function(err,rows,fields){
   if (err) throw err;
    })
  });*/

此查询导致错误，我做错了什么？

This query causes an error, what am I doing wrong?

推荐答案

你做错了是你试图将你的两个值连接成一个字符串并拥有该字符串替换为您的单个？。如果您使用单个？，则需要传入一个对象的参数与数据库字段名称相同的对象。

What you're doing wrong is that you're trying to concatenate your two values into a single string and have that string substituted into your single ?. If you're using a single ?, you need to pass in an object where the object's parameters are the same as the database field names.

我这样做：

let payload = {
    UsernameDB: data.RegUsername,
    PasswordDB: data.Regpassword
};

connection.query("INSERT INTO Codify SET ?", payload, function(err, rows) {

});

您也可以使用数组而不是对象来执行此操作：

You can also do it like this with an array instead of an object:

let sql = "INSERT INTO Codify (UsernameDB, PasswordDB) VALUES (?, ?)";
connection.query(sql, [ data.RegUsername, data.Regpassword ], function(err, rows) {

});

或者像这样：

let sql = "INSERT INTO Codify SET UsernameDB = ?, PasswordDB = ?";
connection.query(sql, [ data.RegUsername, data.Regpassword ],  function(err, rows) {

});

但我发现使用单个？对象更具可读性。

But I find using a single ? along with an object is more readable.

这篇关于Node-mysql插入带有两个值的查询？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！