如何获取具有表的列名的数组

const mysql = require('mysql');

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

  connection.connect();

  return new Promise((resolve, reject) => {
    connection.query(`SHOW COLUMNS FROM ${tableName}`, (error, results) => {
      if (error) {
        reject(error);
      } else {
        const columnNames = results.map(result => result.Field);
        resolve(columnNames);
      }
    });
  });
}

// 调用示例
getTableColumnNames('table_name')
  .then(columnNames => {
    console.log(columnNames);
  })
  .catch(error => {
    console.error(error);
  })
  .finally(() => {
    connection.end();
  });