Node.js MySQL Create Table
Introduction: Learn to create a table in MySQL database using NodeJS. We will see how to use the Create Table command in NodeJS using the MySQL module.
Prerequisite: Introduction to NodeJS MySQL
Setting up environment and Execution:
Step 1: Create a NodeJS Project and initialize it using the following command:
npm init
Step 2: Install the express and mysql modules using the following command:
npm install express npm install mysql
File Structure: Our file structure will look like the following:
Example: Create and export MySQL Connection Object as shown below:
Filename: sqlConnection.js
const mysql = require("mysql");
let db_con = mysql.createConnection({
host: "localhost",
user: "root",
password: '',
database: 'gfg_db'
});
db_con.connect((err) => {
if (err) {
console.log("Database Connection Failed !!!", err);
} else {
console.log("connected to Database");
}
});
module.exports = db_con;
Example 1: Creating a table without a primary key.
const express = require("express");
const database = require('./sqlConnection');
const app = express();
app.get("/", (req, res) => {
let tableName = 'gfg_table';
// Query to create table
let query = `CREATE TABLE ${tableName} (
name VARCHAR(255), address VARCHAR(255))`;
database.query(query, (err, rows) => {
if(err) return res.status(500)
.send("Table Creation Failed");
return res.send(
`Successfully Created Table - ${tableName}`);
})
});
app.listen(5000, () => {
console.log(`Server is up and running on 5000 ...`);
});
Run the index.js file using the following command:
node index.js
Output:
Successfully Created Table - gfg_table
Example 2: Create a Table with an auto-increment primary key.
const express = require("express");
const database = require('./sqlConnection');
const app = express();
app.get("/", (req, res) => {
let tableName = 'gfg_table';
// Query to create table
let query = `CREATE TABLE ${tableName}
(id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255), address VARCHAR(255))`;
database.query(query, (err, rows) => {
if(err) return res.status(500)
.send("Table Creation Failed");
return res.send(
`Successfully Created Table - ${tableName}`);
})
});
app.listen(5000, () => {
console.log(`Server is up and running on 5000 ...`);
});
Run the index.js file using the following command:
node index.js
Output:
Successfully Created Table - gfg_table
