无法使用mysql和nodejs将动态行插入到表中

const mysql = require('mysql');

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

// 连接到MySQL数据库
connection.connect();

// 创建表（如果不存在）
const createTableQuery = 'CREATE TABLE IF NOT EXISTS mytable (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255), age INT)';
connection.query(createTableQuery, (error, results, fields) => {
  if (error) throw error;
  console.log('Table created successfully');
});

// 构建动态行数据
const dynamicRow = {
  name: 'John',
  age: 25
};

// 插入动态行数据
const insertQuery = 'INSERT INTO mytable SET ?';
connection.query(insertQuery, dynamicRow, (error, results, fields) => {
  if (error) throw error;
  console.log('Row inserted successfully');
});

// 关闭与MySQL数据库的连接
connection.end();