import * as mysql from 'mysql';

const connection = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: 'password',
  database: 'mydb'
});

connection.connect((err) => {
  if (err) throw err;
  console.log('Connected to database');
});

const query1 = "SELECT * FROM table1";
const query2 = "SELECT * FROM table2";

new Promise((resolve, reject) => {
  connection.query(query1, (err, results) => {
    if (err) {
      reject(err);
    } else {
      resolve(results);
    }
  });
}).then((result1) => {
  console.log(result1);
  return new Promise((resolve, reject) => {
    connection.query(query2, (err, results) => {
      if (err) {
        reject(err);
      } else {
        resolve(results);
      }
    });
  });
}).then((result2) => {
  console.log(result2);
}).catch((err) => {
  console.error(err);
}).finally(() => {
  connection.end();
});