/Javascript/Node.js/How to use online mysql database with node js

How to use online mysql database with node js

How to manage a db connection in javascript

//put these lines in a seperate file
const mysql = require('mysql2');

const connection = mysql.createPool({
    host: "localhost",
    user: "",
    password: "",
    database: ""
    // here you can set connection limits and so on
});

module.exports = connection;

//put these on destination page
const connection = require('../util/connection');

async function getAll() {
    const sql = "SELECT * FROM tableName";
    const [rows] = await connection.promise().query(sql);
    return rows;
} 
exports.getAll = getAll;

Source: stackoverflow.com

How to use online mysql database with node js

Connected

Similar codes

29 votes164 views3 answers
Node js version
Javascript Node.js
2 votes161 views2 answers
Samesite cookie nodejs
Javascript Node.js
2 votes157 views1 answer
Node print stdin
Javascript Node.js
0 vote156 views1 answer
How to use begins with in aws nodejs
Javascript Node.js
50 votes317 views6 answers
Node update to latest version
Javascript Node.js
20 votes174 views2 answers
Node js quit
Javascript Node.js
0 vote156 views1 answer
Cross-origin request blocked the same origin policy disallows reading the remote resource fix in node js node js
Javascript Node.js
1 vote157 views1 answer
Node redisjson remove path
Javascript Node.js
0 vote162 views1 answer
How to use a fixed time zone in nodejs
Javascript Node.js
8 votes156 views2 answers
Payload too large nodejs
Javascript Node.js