将knex的查询结果传递给变量

const knex = require('knex')({
  client: 'mysql',
  connection: {
    host: 'your_database_host',
    user: 'your_username',
    password: 'your_password',
    database: 'your_database'
  }
});

async function getQueryResult() {
  try {
    const result = await knex('your_table').select('*');
    return result;
  } catch (error) {
    console.error(error);
    throw error;
  } finally {
    knex.destroy();
  }
}

async function main() {
  try {
    const queryResult = await getQueryResult();
    // 在这里可以对查询结果进行处理
    console.log(queryResult);
  } catch (error) {
    console.error(error);
  }
}

main();