/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 vote343 views1 answer
Firestore return the content of an aarray Nodejs
Javascript Node.js
0 vote343 views2 answers
Begins_with node js AWS dynamodb sort key
Javascript Node.js
0 vote334 views1 answer
Node mongodb select collection
Javascript Node.js
2 votes342 views1 answer
Node console showing object object
Javascript Node.js
1 vote362 views2 answers
How ot send user agent in nodejs https header
Javascript Node.js
23 votes326 views5 answers
Node js server
Javascript Node.js
21 votes363 views2 answers
Delete all childs in node
Javascript Node.js
-1 vote371 views1 answer
Mysql node js github
Javascript Node.js
0 vote328 views1 answer
Regex to get part of word nodejs
Javascript Node.js
8 votes331 views2 answers
How to delete cookie node js
Javascript Node.js