Count number of records in MYSQL table by using Node.js

In this article, we are going to learn how to count number of records in MYSQL table using Node.js server?
Submitted by Manu Jemini, on November 24, 2017

Prerequisite/recommended:

In this article, we are going to do is to prepare a server file of node.js where we require the MySQL module to work with MySQL and after that, we prepare a connection by using mysql.createConnection() method of MySQL module.

There are certain things that we have to define inside our create connection method like host, user, password and database name.

Now that we are all set to go with our connection, all we need to create a SQL query to count data basically a select query and after that we can use query() method to execute query statement with a callback in which we can throw error if any and print the number of records available in MYSQL table.

Database details:

Hostname: localhost
Port number: 3306
Username: root
Password: 123
Database: demo
Table name: clients

Server File

//step-1
var mysql = require('mysql');
//step-2
var con = mysql.createConnection({
  host: "127.0.0.1",
  user: "root",
  password: "123",
  database: "demo"
});
//step-3
con.connect(function(err) {
  if (err) throw err;
  console.log("Connected!");
  var sql = "select COUNT(*) from clients";
//step-4
  con.query(sql, function (err, result) {
    if (err) throw err;
    console.log(result);
  });
});

Discussing steps that we have followed in our server file:

Require MySQL module.
Create Connection variable using mysql.createConnection() method.
Connect by using con.connect() method.
Creating a select SQL query with count.
Execute query by using .query() method.
Shows affected records.

Output/result

Node.js - count table records in Node.js