Home » Node.js

Display data from two different tables in MYSQL table by using Node.js

In this article, we are going to learn how to display data from two different tables in MYSQL table using Node.js server?
Submitted by Manu Jemini, on December 10, 2017


As we all know from our previous articles, we need to start with our preparation for a server file of node.js where we require the MySQL module to work on MySQL and then we prepare a connection by using mysql.createConnection() method.

Some certain attributes like the host, user, password, and database name should be there for defining inside our create connection method.

Now we are all set to go with our connection, all we need to create an SQL query basically a select query to display all the data from two different tables and after that we can use query() method to execute query statement with a callback in which we can throw an 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
  • Tables name: clients, city

Steps, we are need to follow:

  • Require MySQL module.

  • Create Connection variable using mysql.createConnection() method.
  • Connect by using con.connect() method.
  • Creating a select SQL query to select data from both the tables.
  • Execute query by using .query() method.
  • Show result.

Note: Symbol (*) means all in SQL.

Server File

var mysql = require('mysql');
var con = mysql.createConnection({
  host: "",
  user: "root",
  password: "123",
  database: "demo"
con.connect(function(err) {
  if (err) throw err;
  var sql = "Select A.*, B.* from clients A,city B ";

  con.query(sql, function (err, result) {
    if (err) throw err;


Node.js - display data from two different tables of MySQL

If you have any query do comment.

Comments and Discussions!

Load comments ↻

Copyright © 2024 www.includehelp.com. All rights reserved.