如何使用mysql和knex js (Node js)插入数组中存储的多条JSON记录？

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255),
    email VARCHAR(255)
);

const users = [
    { name: 'Alice', email: 'alice@example.com' },
    { name: 'Bob', email: 'bob@example.com' },
    { name: 'Charlie', email: 'charlie@example.com' }
];

const knex = require('knex')({
    client: 'mysql',
    connection: {
        host: '127.0.0.1',
        user: 'your_database_user',
        password: 'your_database_password',
        database: 'your_database_name'
    }
});

async function insertUsers(users) {
    try {
        await knex.batchInsert('users', users, 100); // 批量插入，每次插入100条记录
        console.log('Users inserted successfully');
    } catch (error) {
        console.error('Error inserting users:', error);
    } finally {
        await knex.destroy(); // 关闭数据库连接
    }
}

insertUsers(users);