News for hackers. Stuff that matters.
Re:Q – Run SQL Directly on CSV or TSV Files by ClashTheBunny on Wednesday November 05, 2014 @11:46AM (#8562689)
If you want to just drop CSV files into MySQL, go for it with using the CSV file backing: http://dev.mysql.com/doc/refman/5.0/en/csv-storage-engine.ht...

As the comments say, create the table with a CSV storage backing and then delete the file and symlink any file to the same location. You are now querying your quicken export or your excel file.

There are no comments on this comment yet.