如何在NodeJs中移除TextRow并向JSON中添加字符串

npm init -y
npm install mysql

const mysql = require('mysql');

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

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

// 查询数据并处理结果
connection.query('SELECT * FROM your_table_name', function (error, results, fields) {
  if (error) throw error;

  // 移除TextRow并向JSON中添加字符串
  const modifiedResults = results.map(row => {
    const modifiedRow = {};
    for (const field of fields) {
      modifiedRow[field.name] = row[field.name].toString();
    }
    return modifiedRow;
  });

  // 打印修改后的结果
  console.log(modifiedResults);

  // 关闭数据库连接
  connection.end();
});

node index.js