/Javascript/Node.js/Nodejs mysql connection

Nodejs mysql connection

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

Nodejs mysql connection

let connection = mysql.createConnection({
    host: 'localhost',
    user: 'root',
    password: '',
    database: 'todoapp'
});
Code language: JavaScript (javascript)

Source: mysqltutorial.org

Nodejs mysql connection

connection.connect(function(err) {
  if (err) {
    return console.error('error: ' + err.message);
  }

  console.log('Connected to the MySQL server.');
});
Code language: JavaScript (javascript)

Source: mysqltutorial.org

Similar codes

0 vote217 views1 answer
Node js middleware for parsing formdata
Javascript Node.js
13 votes228 views4 answers
Writefile in node js
Javascript Node.js
91 votes252 views4 answers
How to install node js 14 on ubuntu
Javascript Node.js
0 vote197 views1 answer
How to wait for an exec command to fininsh in nodejs
Javascript Node.js
0 vote232 views1 answer
Node js add new object to object array json
Javascript Node.js
0 vote251 views2 answers
Express-rate-limit nodejs
Javascript Node.js
0 vote210 views1 answer
Access to XMLHttpRequest has been blocked by CORS policy node js
Javascript Node.js
0 vote221 views1 answer
Node module es6
Javascript Node.js
0 vote198 views1 answer
Nodejs get prosses id
Javascript Node.js
0 vote285 views1 answer
App listen in node js
Javascript Node.js