What are some examples of MySQL node insertion queries with a pair of values?

Question

What are some examples of MySQL node insertion queries with a pair of values?

I need help with my current JavaScript code snippet.

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 specific SQL query is causing an error for me, can anyone please point out what I am doing incorrectly?

javascript mysql insert node-mysql

Answer 1

Answer №1

The mistake you're making is attempting to combine your two values into a single string and then substituting that string into a single ?. When using a single ?, you should pass in an object where the object's properties match the database field names.

You could approach it like this:

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

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

});

Another way is by using an array instead of an object:

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

});

Alternatively, you can do it like this:

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

});

However, I personally find using a single ? along with an object to be more legible.

Answer 2

The mistake you're making is attempting to combine your two values into a single string and then substituting that string into a single ?. When using a single ?, you should pass in an object where the object's properties match the database field names.

You could approach it like this:

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

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

});

Another way is by using an array instead of an object:

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

});

Alternatively, you can do it like this:

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

});

However, I personally find using a single ? along with an object to be more legible.

Answer 3

Answer №2

When writing queries, it's important to use placeholders like the ? character to escape your data and prevent SQL injection attacks. Instead of concatenating strings in your query, insert each value using placeholders. For example:

("INSERT INTO UserData (Username , Password) VALUES (?,?)", [userData.username, userData.password])

For more information on how to properly escape query values in Node.js MySQL driver, check out the documentation here.

Answer 4

When writing queries, it's important to use placeholders like the ? character to escape your data and prevent SQL injection attacks. Instead of concatenating strings in your query, insert each value using placeholders. For example:

("INSERT INTO UserData (Username , Password) VALUES (?,?)", [userData.username, userData.password])

For more information on how to properly escape query values in Node.js MySQL driver, check out the documentation here.

What are some examples of MySQL node insertion queries with a pair of values?

Answer №1

Answer №2

Similar questions

Utilize React's debounce feature in conjunction with updating state using

Is there a specific index range in javascript or nodejs for accessing array items?

Using jQuery to Retrieve an Element's Class Through an AJAX Call

Tips on organizing orders by various cities with Laravel, MySQL, and JSON

Adjusting the color of specific sections within a text box

Verify whether the value of the Object matches the value of the string

Unable to retrieve a return value from an asynchronous waterfall function within a node module

Emberjs Troubleshooting: Issue with Sending Many-To-Many JSON Parameters

A guide to specifying the Key-Callback pair types in Typescript

Updating or editing data in a database using AngularJS: A step-by-step guide

Having trouble parsing data in a jQuery REST call

Utilize AngularJS to load pages through a single state

Challenge with AngularJS ng-select and ng-switch-when functionality

The inline style fails to take effect on input elements that are generated dynamically

The web browser's engine is blocking the connection to the secure websocket server

Logging into a MySQL database on an Android device

Bring in resources without specifying

How to retrieve the first option selected in Material-UI React?

Unable to render data in Chart JS using PHP JSON

Unexpected glitch: three.js texture turns completely black