To fetch data from MySQL using Node.js:
Connect to MySQL
Run a SELECT SQL query
Retrieve the result rows
npm install mysql2
1 2 3 4 5 6 7 8 |
const mysql = require("mysql2"); const connection = mysql.createConnection({ host: "localhost", user: "root", password: "", database: "mydb" }); |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
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 = "SELECT * FROM users"; connection.query(sql, (err, rows) => { if (err) throw err; console.log(rows); connection.end(); }); }); |
1 2 3 4 |
[ { id: 1, name: "John Doe", email: "john@example.com", created_at: "2025-01-12" }, { id: 2, name: "Alice", email: "alice@example.com", created_at: "2025-01-12" } ] |
1 2 3 4 5 6 7 |
connection.query( "SELECT name, email FROM users", (err, rows) => { if (err) throw err; console.log(rows); } ); |
1 2 3 4 5 6 7 8 |
connection.query( "SELECT * FROM users WHERE id = ?", [1], (err, rows) => { if (err) throw err; console.log(rows); } ); |
1 2 3 4 5 6 7 8 |
connection.query( "SELECT * FROM users WHERE name = ? AND email = ?", ["John Doe", "john@example.com"], (err, rows) => { if (err) throw err; console.log(rows); } ); |
1 2 3 4 5 6 7 |
connection.query( "SELECT * FROM users ORDER BY id DESC", (err, rows) => { if (err) throw err; console.log(rows); } ); |
1 2 3 4 5 6 7 |
connection.query( "SELECT * FROM users LIMIT 5", (err, rows) => { if (err) throw err; console.log(rows); } ); |
Using mysql2/promise:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 |
const mysql = require("mysql2/promise"); async function getUsers() { const connection = await mysql.createConnection({ host: "localhost", user: "root", password: "", database: "mydb" }); const [rows] = await connection.execute("SELECT * FROM users"); console.log(rows); await connection.end(); } getUsers(); |
1 2 3 4 5 6 7 |
const sql = "SELECT * FROM users WHERE email = ?"; const values = ["john@example.com"]; connection.execute(sql, values, (err, rows) => { if (err) throw err; console.log(rows); }); |
by CodeCapsule · Published December 12, 2025
by CodeCapsule · Published December 12, 2025
by CodeCapsule · Published December 12, 2025