Use MySQL LOAD DATA INFILE using node.js?

Question

Are there 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 cannot find any node.js drivers that clearly indicate its support.

Answer 1

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

Answer 2

Just make sure it works:

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