/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

4 votes172 views3 answers
Node js kill port
Javascript Node.js
7 votes174 views3 answers
Generate random number nodejs
Javascript Node.js
2 votes194 views1 answer
An error occurred while applying security settings node js
Javascript Node.js
7 votes211 views4 answers
Node downgrade windows
Javascript Node.js
0 vote225 views1 answer
Node js load css file
Javascript Node.js
4 votes202 views3 answers
413 payload too large nodejs
Javascript Node.js
13 votes203 views4 answers
Node version manager install
Javascript Node.js
1 vote191 views1 answer
Node js get time in timezone
Javascript Node.js
34 votes193 views2 answers
Module export in node js
Javascript Node.js
51 votes353 views6 answers
Generate random number in node js
Javascript Node.js