js如何处理mysql

const mysql = require('mysql');
const connection = mysql.createConnection({
  host: 'localhost',
  user: 'username',
  password: 'password',
  database: 'database_name'
});

connection.query('SELECT * FROM users', (err, rows) => {
  if (err) throw err;
  console.log(rows);
});

const values = ['John Doe', 'john.doe@example.com'];
connection.query('INSERT INTO users (name, email) VALUES (?)', [values], (err, result) => {
  if (err) throw err;
  console.log(`Inserted user with id: ${result.insertId}`);
});

connection.query('UPDATE users SET name = ? WHERE id = ?', ['Jane Doe', 1], (err, result) => {
  if (err) throw err;
  console.log(`Updated user with id: ${result.affectedRows}`);
});

connection.query('DELETE FROM users WHERE id = ?', [1], (err, result) => {
  if (err) throw err;
  console.log(`Deleted user with id: ${result.affectedRows}`);
});

connection.end();