How to import csv file into mysql database using express js and sequelize

Question

I want to import csv file data into mysql database table I can do it using only mysql query but I am not able to do it by sequelize and express js please help me. Thanks in advance.

Reventlow · Accepted Answer · 2019-03-15 19:20:06Z

2

you need to use seeders. see the docs here on making and running seeds http://docs.sequelizejs.com/manual/migrations.html#creating-first-seed

you also need to convert your CSV to SQL. see here https://blog.sqlizer.io/posts/convert-csv-to-sql/

The format for RAW SQL in your seeder is listed below

module.exports = {
  up: queryInterface => queryInterface.sequelize.query(`
      // RAW QUERY HERE
  `),
};
,,,

answered Mar 15, 2019 at 19:20

Reventlow

413 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to import csv file into mysql database using express js and sequelize

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related