Node JS - Node js MySQL Insert - Node - Node JS tutorial - webnode




Insert Into Table

  • INSERT INTO statement is used to insert records in MySQL.
  • To fill a table in MySQL, use the "INSERT INTO" statement.
 node-js mysql insert table

Learn Node js - node js Tutorial - node-js mysql insert table - node - Node js Examples

Example

Insert a record in the "wikitechy_customers" table:
var mysql = require('mysql');

var con = mysql.createConnection({
  host: "localhost",
  user: "yourusername",
  password: "yourpassword",
  database: "mydb"
});

con.connect(function(err) {
  if (err) throw err;
  console.log("Connected!");
  var sql = "INSERT INTO wikitechy_customers (name, address) VALUES ('Company Inc', 'Highway 37')";
  con.query(sql, function (err, result) {
    if (err) throw err;
    console.log("1 record inserted");
  });
});
  • Save the code above in a file called "wikitechy_db_insert.js", and run the Node JS Tutorial File:
Run "wikitechy_db_insert.js"
C:\Users\Your Name>node wikitechy_db_insert.js

Output

Connected!
1 record inserted

Insert Multiple Records

  • To insert more than one record, make an array containing the values, and insert
INSERT INTO wikitechy_customers (name, address) VALUES ?
Related nodejs article tags - node js - node js tutorial - node js examples

Example

Fill the "wikitechy_customers" table with data:
var mysql = require('mysql');

var con = mysql.createConnection({
  host: "localhost",
  user: "yourusername",
  password: "yourpassword",
  database: "mydb"
});

con.connect(function(err) {
  if (err) throw err;
  console.log("Connected!");
  var sql = "INSERT INTO wikitechy_customers (name, address) VALUES ?";
  var values = [
    ['John', 'Highway 71'],
    ['Peter', 'Lowstreet 4'],
    ['Amy', 'Apple st 652'],
    ['Hannah', 'Mountain 21'],
    ['Michael', 'Valley 345'],
    ['Sandy', 'Ocean blvd 2'],
    ['Betty', 'Green Grass 1'],
    ['Richard', 'Sky st 331'],
    ['Susan', 'One way 98'],
    ['Vicky', 'Yellow Garden 2'],
    ['Ben', 'Park Lane 38'],
    ['William', 'Central st 954'],
    ['Chuck', 'Main Road 989'],
    ['Viola', 'Sideway 1633']
  ];
  con.query(sql, [values], function (err, result) {
    if (err) throw err;
    console.log("Number of records inserted: " + result.affectedRows);
  });
});

  • Save the code above in a file called "wikitechy_db_insert_multple.js", and run the Node JS Tutorial File:
Run "wikitechy_db_insert_multiple.js"
C:\Users\Your Name>node wikitechy_db_insert_multiple.js

Output

Connected!
Number of records inserted: 14

The Result Object

  • When executing a query, a result object is returned.
  • The result object contains information about how the query affected the table.
  • The result object returned from the example above looks like this:
{
  fieldCount: 0,
  affectedRows: 14,
  insertId: 0,
  serverStatus: 2,
  warningCount: 0,
  message: '\'Records:14  Duplicated: 0  Warnings: 0',
  protocol41: true,
  changedRows: 0
}
  • The values of the properties can be displayed like this:

Example

Return the number of affected rows:
console.log(result.affectedRows)

Output

14

Get Inserted ID

  • For tables with an auto increment id field, you can get the id of the row you just inserted by asking the result object.
  • Note: To be able to get the inserted id, only one row can be inserted.

Example

Insert a record in the "wikitechy_customers" table, and return the ID:
var mysql = require('mysql');

var con = mysql.createConnection({
  host: "localhost",
  user: "yourusername",
  password: "yourpassword",
  database: "mydb"
});

con.connect(function(err) {
  if (err) throw err;
  var sql = "INSERT INTO wikitechy_customers (name, address) VALUES ('Michelle', 'Blue Village 1')";
  con.query(sql, function (err, result) {
    if (err) throw err;
    console.log("1 record inserted, ID: " + result.insertId);
  });
});
  • Save the code above in a file called "wikitechy_db_insert_id.js", and run the Node JS Tutorial File:
Run "wikitechy_db_insert_id.js"
C:\Users\Your Name>node wikitechy_db_insert_id.js

Output

1 record inserted, ID: 15

This wikitechy technological portal provides you whole lot of information related to the topics such as mongodb tutorial , what is node js , express js tutorial , node js tutorial pdf , learn node js , node js tutorial for beginners , node js tutorial w3schools , node js express , javascript for beginners , node js express tutorial , node js tutorial point , node js book , node js server , note js , node js mongodb , what is node js used for , why node js , node tutorial , node js basics , tutorialspoint node js , node express , node js sample application , nodeschool , node js for beginners , express tutorial , node js application , use of node js , npm tutorial , node js org , node js training , node js online training , node js tutorial beginner , how to use node js , node js hello world , express node js , node js mongodb tutorial , nodejs http , why use node js

Related Searches to Node.js MySQL Insert

Adblocker detected! Please consider reading this notice.

We've detected that you are using AdBlock Plus or some other adblocking software which is preventing the page from fully loading.

We don't have any banner, Flash, animation, obnoxious sound, or popup ad. We do not implement these annoying types of ads!

We need money to operate the site, and almost all of it comes from our online advertising.

Please add wikitechy.com to your ad blocking whitelist or disable your adblocking software.

×