How to import *.csv file to MySQL

Use http://www.heidisql.com/ for import.
Example SQL for csv import:
LOAD DATA LOCAL INFILE 'C:\\temp\\phantomjs-2.1.1-windows\\bin\\dailydump.csv' 
IGNORE INTO TABLE `q` FIELDS TERMINATED BY '|' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '"' LINES TERMINATED BY '\n' IGNORE 1 LINES (`torrent_info_hash`, `torrent_name`, `torrent_category`, `torrent_info_url`, `torrent_download_url`, `size`, `category_id`, `files_count`, `seeders`, `leechers`, `upload_date`, `verified`);