How to query CSV file from mysql?

Question

How to query csv file using mysql? i have a .csv file and i want to query it so that i could get distinct record value from csv file.

Thanks
Yugal

Pekka · Accepted Answer · 2011-09-06 07:39:02Z

2

You can't. You need to import it into mySQL. mySQL's command for that is LOAD DATA INFILE.

answered Sep 6, 2011 at 7:39

Pekka

451k150 gold badges989 silver badges1.1k bronze badges

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

2 Comments

Pekka: is there any other way to import only distinct record from csv file by mysql query?

@yugal I don't think so, no. I think the best way is still to import the whole file into a temporary table, then remove all the unwanted records

Mchl · Accepted Answer · 2011-09-06 07:39:03Z

1

You need to load it into MySQL table first. Then query as usual.

Alternatively you can try experimenting with CSV storage engine.

answered Sep 6, 2011 at 7:39

Mchl

62.4k9 gold badges121 silver badges121 bronze badges