csv2mysql

Promise import csv file to mysql table

Install

npm install csv2mysql

Use

csv2mysql([options], [path]);

Options

• host: ip or domain
• user: mysql username
• password: mysql password
• database: mysql database name
• table: mysql table name
• csv: csv parser config fast-csv documentation

Example

var csv2mysql = require('csv2mysql');
csv2mysql({
    host: '127.0.0.1',
    user: 'root',
    password: 'root',
    database: 'csv2mysql',
    table: 'myTable',
    csv: {
        delimiter: ';'
    }
}, './test.csv')
    .then(function() {
        console.log("finish");
    })
    .catch(function(errors) {
        console.log(errors);
    });

License

MIT