Node.js MySQL Insert Into

🚀 Node.js MySQL – INSERT INTO

To insert data into MySQL using Node.js:

Connect to the database
Use an SQL INSERT statement
Execute using connection.query() or connection.execute() (prepared statement)

✅ 1. Install mysql2

✅ 2. Connect to MySQL Database

Example: Using database mydb

✅ 3. Insert a Single Record

insert_one.js

const mysql = require("mysql2");

const connection = mysql.createConnection({
host: "localhost",
user: "root",
password: "",
database: "mydb"
});

connection.connect((err) => {
if (err) throw err;
console.log("Connected!");

const sql = "INSERT INTO users (name, email) VALUES (?, ?)";
const values = ["John Doe", "john@example.com"];

connection.query(sql, values, (err, result) => {
if (err) throw err;
console.log("Record Inserted! Insert ID:", result.insertId);
connection.end();
});
});

const mysql = require("mysql2");

const connection = mysql.createConnection({

host: "localhost",

user: "root",

password: "",

database: "mydb"

});

connection.connect((err) => {

if (err) throw err;

console.log("Connected!");

const sql = "INSERT INTO users (name, email) VALUES (?, ?)";

const values = ["John Doe", "john@example.com"];

connection.query(sql, values, (err, result) => {

if (err) throw err;

console.log("Record Inserted! Insert ID:", result.insertId);

connection.end();

});

📝 Output Example

✅ 4. Insert Multiple Records

const sql = "INSERT INTO users (name, email) VALUES ?";
const values = [
["Mark", "mark@example.com"],
["Lisa", "lisa@example.com"],
["Kevin", "kevin@example.com"]
];

connection.query(sql, [values], (err, result) => {
if (err) throw err;
console.log(result.affectedRows + " records inserted");
});

const sql = "INSERT INTO users (name, email) VALUES ?";

const values = [

["Mark", "mark@example.com"],

["Lisa", "lisa@example.com"],

["Kevin", "kevin@example.com"]

];

connection.query(sql, [values], (err, result) => {

if (err) throw err;

console.log(result.affectedRows + " records inserted");

});

✅ 5. Insert with Prepared Statements (Recommended)

Protects from SQL injection.

✅ 6. Insert Using Async/Await (Best Way)

(Using mysql2 promise API)

insert_async.js

const mysql = require("mysql2/promise");

async function insertUser() {
const connection = await mysql.createConnection({
host: "localhost",
user: "root",
password: "",
database: "mydb"
});

const sql = "INSERT INTO users (name, email) VALUES (?, ?)";
const values = ["Chris", "chris@example.com"];

const [result] = await connection.execute(sql, values);
console.log("Insert ID:", result.insertId);

await connection.end();
}

insertUser();

const mysql = require("mysql2/promise");

async function insertUser() {

const connection = await mysql.createConnection({

host: "localhost",

user: "root",

password: "",

database: "mydb"

});

const sql = "INSERT INTO users (name, email) VALUES (?, ?)";

const values = ["Chris", "chris@example.com"];

const [result] = await connection.execute(sql, values);

console.log("Insert ID:", result.insertId);

await connection.end();

}

insertUser();

📌 7. Insert with Currents Timestamp Auto

If your table uses:

Then you don’t need to insert the date — it fills automatically.

🎯 8. Checking Inserted Data

After insert, you can check:

Or create a small Node query to fetch data.

Node.js MySQL Insert Into

🚀 Node.js MySQL – INSERT INTO

✅ 1. Install mysql2

✅ 2. Connect to MySQL Database

✅ 3. Insert a Single Record

insert_one.js

📝 Output Example

✅ 4. Insert Multiple Records

✅ 5. Insert with Prepared Statements (Recommended)

✅ 6. Insert Using Async/Await (Best Way)

insert_async.js

📌 7. Insert with Currents Timestamp Auto

🎯 8. Checking Inserted Data

You may also like...

Node.js Tutorials

Node.js MySQL Insert Into

🚀 Node.js MySQL – INSERT INTO

✅ 1. Install mysql2

✅ 2. Connect to MySQL Database

✅ 3. Insert a Single Record

insert_one.js

📝 Output Example

✅ 4. Insert Multiple Records

✅ 5. Insert with Prepared Statements (Recommended)

✅ 6. Insert Using Async/Await (Best Way)

insert_async.js

📌 7. Insert with Currents Timestamp Auto

🎯 8. Checking Inserted Data

You may also like...

Node.js MySQL Create Database

Node.js MongoDB Create Collection

Node.js MySQL Where

Node.js Tutorials