mysql和Node JS无法实现CRUD操作

const mysql = require('mysql');

// 创建数据库连接
const connection = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: 'your_password',
  database: 'your_database'
});

// 连接到数据库
connection.connect((err) => {
  if (err) throw err;
  console.log('Connected to MySQL database');
});

// 执行CRUD操作
// 创建一条记录
const createRecord = (data) => {
  connection.query('INSERT INTO your_table SET ?', data, (err, result) => {
    if (err) throw err;
    console.log('Record created successfully');
  });
};

// 读取记录
const readRecords = () => {
  connection.query('SELECT * FROM your_table', (err, results) => {
    if (err) throw err;
    console.log(results);
  });
};

// 更新记录
const updateRecord = (id, data) => {
  connection.query('UPDATE your_table SET ? WHERE id = ?', [data, id], (err, result) => {
    if (err) throw err;
    console.log('Record updated successfully');
  });
};

// 删除记录
const deleteRecord = (id) => {
  connection.query('DELETE FROM your_table WHERE id = ?', id, (err, result) => {
    if (err) throw err;
    console.log('Record deleted successfully');
  });
};

// 关闭数据库连接
connection.end((err) => {
  if (err) throw err;
  console.log('Disconnected from MySQL database');
});

// 调用以上函数进行相应操作