node mysql工具

const mysql = require('mysql');

const connection = mysql.createConnection({
  host: 'localhost',
  user: 'your_username',
  password: 'your_password',
  database: 'your_database'
});

connection.connect((err) => {
  if (err) {
    console.error('Error connecting to MySQL:', err);
    return;
  }
  console.log('Connected to MySQL!');
});

const query = 'CREATE DATABASE IF NOT EXISTS your_database';
connection.query(query, (err, results) => {
  if (err) throw err;
  console.log('Database created or already exists!');
});

const pool = mysql.createPool({
  connectionLimit: 10,
  host: 'localhost',
  user: 'your_username',
  password: 'your_password',
  database: 'your_database'
});

pool.getConnection((err, connection) => {
  if (err) throw err;
  connection.query('SELECT 1 + 1 AS solution', (error, results, fields) => {
    connection.release(); // 释放连接回连接池
    if (error) throw error;
    console.log('The solution is:', results[0].solution);
  });
});