Home » Node.js

Create another table in same MySQL database by using Node.js

In this article, we are going to learn how to make/create a table in same MYSQL database by using Node.js?
Submitted by Manu Jemini, on November 21, 2017


First of all, we are going to require the MySQL module and take it’s reference in a local variable so that we can get all of its methods.

Then create a connection we use MySQL module reference and after that, we establish a connection by using its .createConnection() method and initialize host, username and password and database name.

Now the last thing we do is to invoke .connect() method with a callback function and create a query string to create a table name city with their fields id and cityname. Now using .query() method we execute our query and in callback function, we manage a condition to throw an error if any and shows a message that Table created.

Database details:

  • Hostname: localhost
  • Port number: 3306
  • Username: root
  • Password: 123
  • Database: demo

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 = "CREATE TABLE city (id INT PRIMARY KEY, cityname VARCHAR(50))";

  con.query(sql, function (err, result) {
    if (err) throw err;
    console.log("Table created");

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 SQL query.
  • Execute query by using .query() method.
Node.js - create a MySQL table

create a MySQL table in Node.js

If you have any query do comment.

Comments and Discussions!

Load comments ↻

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