使用带有节点js的knex将json文件数据插入到mysql

npm install knex mysql

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

const jsonData = fs.readFileSync('data.json');
const data = JSON.parse(jsonData);

knex('your_table_name')
  .insert(data)
  .then(() => {
    console.log('Data inserted successfully');
    knex.destroy();
  })
  .catch((error) => {
    console.error('Error inserting data:', error);
    knex.destroy();
  });

node insertData.js