Knex.js:如何创建表、插入数据、获取select查询结果，然后返回

 client: 'mysql', // 数据库类型，可以是 mysql、postgresql、sqlite3 等

 connection: {

   host: 'your_host',

   user: 'your_user',

   password: 'your_password',

   database: 'your_database',

 },

 table.increments('id');

 table.string('name');

 table.string('email').unique();

 table.timestamps(false, true);

 console.log('Table created successfully');

 console.error('Error creating table:', error);

 knex.destroy();

 .insert({ name: 'John Doe', email: 'johndoe@example.com' })

 .then(() => {

   console.log('Data inserted successfully');

 })

 .catch((error) => {

   console.error('Error inserting data:', error);

 })

 .finally(() => {

   knex.destroy();

 });

 .select('name', 'email')

 .then((rows) => {

   console.log('Query result:', rows);

 })

 .catch((error) => {

   console.error('Error querying data:', error);

 })

 .finally(() => {

   knex.destroy();

 });