使用knexjs中的current_timestamp()更新mysql的触发器

npm install knex mysql

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

knex.schema.raw(`
  CREATE TRIGGER update_timestamp
  BEFORE UPDATE ON your_table
  FOR EACH ROW
  SET NEW.timestamp_column = current_timestamp();
`)
  .then(() => {
    console.log('Trigger created successfully');
  })
  .catch((error) => {
    console.error('Error creating trigger:', error);
  })
  .finally(() => {
    knex.destroy();
  });