Node Api rest - change database dynamically|

Solution 1:

Before you use the query to select a table from a database, you need to switch the database, use this query to achieve that.

con.query("USE your_db_name", function (err, result, fields) {
    if (err) throw err;
    console.log(result);
  });

then after it use the query that you want like this

const mysql = require("../db").pool1;

exports.adminGroup = (req, res, next) => {
  mysql.getConnection((error, conn) => {
    if (error) {
      return res.status(500).send({ error: error });
    }
con.query("USE your_db_name", function (err, result, fields) {
        if (err) throw err;
        console.log(result);
      });
    conn.query(
      "INSERT INTO adminGroup SET ?",
      [req.body],
      (error, results) => {
        conn.release();
        if (error) {
          return res.status(500).send({ error: error });
        }
        response = {
          mensagem: "Group add",
          grupoCriado: {
            id: results.insertId,
            grupo: req.body.group,
          },
        };
        return res.status(201).send(response);
      }
    );
  });
};