How to query CSV file from mysql?

How to q开发者_如何学JAVAuery 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

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

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

Alternatively you can try experimenting with CSV storage engine.