Use MySQL's LOAD DATA INFILE with node.js?

Question

Are there any node.js MySQL drivers that support LOAD DATA INFILE (http://dev.mysql.com/doc/refman/5.0/en/load-data.html)? I have some utilities that rely heavily on bulk insertion, and can't find any node.js drivers that explicitly mention supporting it.

score 1 · Answer 1 · answered Oct 10 '15 at 07:12

1

Just verified that it works:

conn.query('LOAD DATA LOCAL INFILE ? INTO TABLE my_table (col1, col2)', 
  [pathToFile], 
  function(err) {
    //done
  });

answered Oct 10 '15 at 07:12

Evan Siroky

9,040
6
54
73

It works for me as above using the NPM mysql library - not the mysql2 (bummer). – RobMac May 18 '23 at 20:24

score 1 · Answer 2 · answered Sep 06 '11 at 09:24

1

This post suggests that the felixge driver supports LOAD DATA INFILE.

answered Sep 06 '11 at 09:24

davidethell

11,708
6
43
63

Use MySQL's LOAD DATA INFILE with node.js?

2 Answers2