/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

0 vote166 views1 answer
How to get datetime in nodejs
Javascript Node.js
18 votes168 views2 answers
Node gitignore
Javascript Node.js
0 vote180 views1 answer
Nodejs postgresql scalar query
Javascript Node.js
3 votes145 views3 answers
Node get current url
Javascript Node.js
10 votes176 views2 answers
Moment string to date convert node js
Javascript Node.js
24 votes195 views4 answers
Node if file exists
Javascript Node.js
15 votes183 views2 answers
Write json file nodejs
Javascript Node.js
0 vote172 views1 answer
Detect nodejs
Javascript Node.js
0 vote193 views1 answer
Crud mongodb node js github
Javascript Node.js
0 vote175 views1 answer
Chocolatey nodejs
Javascript Node.js