CODE EXAMPLE FOR SQL

load a log file in that format into MySQL

Copied
LOAD DATA INFILE '/local/access_log' INTO TABLE tbl_name
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY ''