SQL Server multiple database nodejs connection

Question

I want to connect to SQL Server where I have few databases. I am using mysql library for nodejs. What I want to achieve is to connect to SQL Server and query different databases based on send query like this.

SELECT * FROM db1 where id = 1

SELECT * FROM db2 where id = 2

etc

My code:

const express = require('express')
const mysql = require('mysql')
const fs = require('fs');
const app = express()

const db = mysql.createConnection({
    host: '',
    user: '',
    password: '',
    database: '' // I want to pass db name in SQL query below not here
})
db.connect()

app.get('/', (req, res) => {
 //and here i want to pass db name in query not in above.
 //so every query that i send will contain db
    const sql = 'SELECT * FROM users'

    db.query(sql, (err, result) => {
        if (err) throw err;
        res.json(result)
    })
})

app.listen(5000, () => {
    console.log('Server started')
})

BraveButter · Accepted Answer · 2019-05-07 12:42:20Z

4

You can just omit the database attribute in the createConnection object. See Establishing connections

...

const db = mysql.createConnection({
    host: '',
    user: '',
    password: ''
})

db.connect()

...

answered May 7, 2019 at 12:42

BraveButter

1,4589 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Exc Over a year ago

thanks, can i console.log(db.connect())?? to check if is connected

BraveButter Over a year ago

console.log in general is a bad practise to check variables, just set a breakpoint and use the debugger ( nodejs.org/de/docs/guides/debugging-getting-started ). But you can just inspect the db object there should be a property connected

BraveButter Over a year ago

If my answer helped and fix you problem i would appreciate if you set it as correct answer :)

hnafar Over a year ago

This answer is related to MySql, whereas the question was specifically about MSSql

BraveButter Over a year ago

the question was tagged as mysql question and in the code example the mysql package was used

Collectives™ on Stack Overflow

SQL Server multiple database nodejs connection

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related