Prerequisite: Create Users table

    create table users(id int primary key auto_increment,
    name varchar(100) not null, email varchar(100) not null,
    password varchar(100) not null, role char(10) not null,
    unique (email),
    check (role in ('USER','ADMIN'))
    );

Task 1: Insert Record

• test_insert.js

    const {DB} = require("./db.js");

    let user = {name:"Naresh", email:"nareshkumarh@live.com", password:"pass123", role:"ADMIN" };

    const params = [user.name, user.email, user.password, user.role];
    const query = 'insert into users (name,email,password,role) value (?,?,?,?)';

    const conn =  new DB().connect();
    conn.query( query, params, function (err, rows) {
            if (err) throw err

            console.log('Id: ', rows.insertId);
    })
    conn.end()

Test

    node test_insert.js
    //Output: It will return the insertId => number