如何使用MySQL语法创建knex请求？

npm install knex mysql

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

knex.schema.createTable('users', function(table) {
  table.increments('id');
  table.string('name');
  table.string('email').unique();
  table.timestamps();
})
.then(function() {
  console.log('Table created successfully!');
})
.catch(function(error) {
  console.log('Error creating table:', error);
})
.finally(function() {
  knex.destroy();
});

knex('users').insert({ name: 'John Doe', email: 'john@example.com' })
.then(function() {
  console.log('Data inserted successfully!');
})
.catch(function(error) {
  console.log('Error inserting data:', error);
})
.finally(function() {
  knex.destroy();
});

knex.select().from('users')
.then(function(rows) {
  console.log('Query result:', rows);
})
.catch(function(error) {
  console.log('Error querying data:', error);
})
.finally(function() {
  knex.destroy();
});