Node.js MySQL Insert Record

Websolutionstuff | Sep-29-2021 | Categories : MySQL Node.js

In this tutorial we will see how to insert data into MySQL table using Node.js. In previous node .js article I will give you example about how to connect MySQL database with Node.js and how to create MySQL database in Node.js.

So, now I will give you information about insert rows into mysql database table from node.js or insert multiple records into mysql using node.js. Before perform this article please make sure create database with connection. So, read below tutorial for connect database.

Example :

var mysql = require('mysql');

var con = mysql.createConnection({
  host: "localhost",
  user: "your_username",
  password: "your_password",
  database: "websolutionstuff"
});

con.connect(function(err) {
  if (err) throw err;
  console.log("Connected..!!");
  var sql = "INSERT INTO users (name, email) VALUES ('websolutionstuff', '[email protected]')";
  con.query(sql, function (err, result) {
    if (err) throw err;
    console.log("Record Inserted Successfully!");
  });
});

Run db_record_demo.js file

node db_record_demo.js

The response with console messages like

Connected..!!
Record Inserted Successfully!

 

 

Insert Multiple Records

Insert more than one record, make an array containing the values, and insert a question mark in the sql, which will be replaced by the value array :

INSERT INTO users (name, email) VALUES ?

Use query() method with SQL statement and data array like below :

connection.query(query, [data]);

Example :

var mysql = require('mysql');

var con = mysql.createConnection({
  host: "localhost",
  user: "your_username",
  password: "your_password",
  database: "websolutionstuff"
});

con.connect(function(err) {
  if (err) throw err;
  console.log("Connected..!");
  var sql = "INSERT INTO users (name, email) VALUES ?";
  var values = [
    ['websolutionstuff', '[email protected]'],
    ['dell', '[email protected]'],
    ['laravel', '[email protected]']
  ];
  con.query(sql, [values], function (err, result) {
    if (err) throw err;
    console.log("Number of records inserted: " + result.affectedRows);
  });
});

Run db_record_demo.js file

node db_record_demo.js

The response with console messages like :

Connected..!!
Number of records inserted: 3

 


You might also like :

Read Also : Laravel 8 Highcharts Example Tutorial

Read Also : Node.js Express CRUD Example with MySQL

Read Also : How To Import CSV File In MySQL Using Node.js

Read Also : How To Check Email Already Exist Or Not In Laravel

Recommended Post
Featured Post
How To Generate PDF and Send Email In Laravel 8
How To Generate PDF and Send E...

In this tutorial we will see how to generate pdf and send email in laravel 8. For generating PDF file we will use l...

Read More

Dec-20-2021

Import Export CSV/EXCEL File In Laravel
Import Export CSV/EXCEL File I...

Today I will show you how to implement/install the import/export package in laravel 6/7. We will simply create...

Read More

May-19-2020

Laravel 9 to_route() and str() Helper Function
Laravel 9 to_route() and str()...

In this article, we will see laravel 9 to_route() and str() helper function. The to_route function g...

Read More

Oct-03-2022

How To Create Custom Helper Function In Laravel 10
How To Create Custom Helper Fu...

In this article, we'll explore how to create a custom helper function in Laravel 10. This custom helper function can...

Read More

Mar-20-2023