如何使用knex做`UPDATE...SET...FROM`？

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

knex('table_name')
  .update({
    field1: 'value1',
    field2: 'value2'
  })

.innerJoin('another_table', 'table_name.id', '=', 'another_table.id')

.where('table_name.field', '=', 'condition_value')

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

knex('table_name')
  .update({
    field1: 'value1',
    field2: 'value2'
  })
  .innerJoin('another_table', 'table_name.id', '=', 'another_table.id')
  .where('table_name.field', '=', 'condition_value')
  .then(() => {
    console.log('Update successful');
    // 其他操作或回调函数
  })
  .catch((error) => {
    console.error('Update failed:', error);
    // 错误处理逻辑
  });