Node.js MySQL Delete

🚀 Node.js MySQL – DELETE Records

The DELETE statement is used to remove records from a MySQL table.

We’ll use mysql2 (recommended) for all examples.

✅ 1. Install mysql2

✅ 2. Connect to Database

✅ 3. Delete a Single Record by ID

Output Example:

✅ 4. Delete Multiple Records Using Conditions

const sql = "DELETE FROM users WHERE name = ? OR email = ?";
const values = ["Alice", "alice@example.com"];connection.query(sql, values, (err, result) => {
if (err) throw err;
console.log("Deleted Rows:", result.affectedRows);
});

const sql = "DELETE FROM users WHERE name = ? OR email = ?";

const values = ["Alice", "alice@example.com"];connection.query(sql, values, (err, result) => {

if (err) throw err;

console.log("Deleted Rows:", result.affectedRows);

});

✅ 5. Delete All Records

⚠️ Be careful! This removes all rows from the table.

✅ 6. Using Async/Await (Recommended)

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

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

const [result] = await connection.execute("DELETE FROM users WHERE id = ?", [id]);
console.log("Deleted Rows:", result.affectedRows);

await connection.end();
}

deleteUser(2);

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

async function deleteUser(id) {

const connection = await mysql.createConnection({

host: "localhost",

user: "root",

password: "",

database: "mydb"

});

const [result] = await connection.execute("DELETE FROM users WHERE id = ?", [id]);

console.log("Deleted Rows:", result.affectedRows);

await connection.end();

}

deleteUser(2);

✅ 7. Tips & Best Practices

Always use WHERE unless you intend to delete all rows.
Use prepared statements (?) to prevent SQL injection.
Wrap in try/catch when using async/await to catch errors.
Consider soft delete (mark as deleted) for critical data instead of hard delete.

Node.js MySQL Delete