Create a seed file for Knex.
knex seed:make seed_name
Change the code to import the data from CSV.
Please refer to the link format of the file.
import seeder from 'knex-csv-seeder';
exports.seed = seeder({
table: 'users',
file: '/path/to/users.csv',
// recordsPerQuery: 100,
// encoding: 'utf8' default encoding
// parser: {
// delimiter: ',',
// quote: '"',
// escape: '\\'
// }
});
Execute the seed files.
knex seed:run