使用节点js在MySQL字段中插入值

const mysql = require('mysql');

const connection = mysql.createConnection({
  host: 'localhost', // 数据库主机名
  user: 'root', // 数据库用户名
  password: 'password', // 数据库密码
  database: 'mydatabase' // 数据库名称
});

connection.connect((err) => {
  if (err) {
    console.error('Error connecting to MySQL database: ' + err.stack);
    return;
  }
  console.log('Connected to MySQL database as id ' + connection.threadId);
});

const insertData = { name: 'John', age: 25 };

connection.query('INSERT INTO mytable SET ?', insertData, (err, results) => {
  if (err) {
    console.error('Error inserting data into MySQL table: ' + err.stack);
    return;
  }
  console.log('Data inserted into MySQL table successfully.');
});

connection.end((err) => {
  if (err) {
    console.error('Error closing MySQL database connection: ' + err.stack);
    return;
  }
  console.log('MySQL database connection closed.');
});