Warning, /RDBC/macros/access_log.mysql is written in an unsupported language. File is not indexed.
0001 DROP TABLE test.access_log;
0002
0003 CREATE TABLE test.access_log
0004 (host VARCHAR(16) not null,
0005 time TIMESTAMP(14) not null,
0006 status smallint not null,
0007 bytes DECIMAL(16),
0008 content varchar(40) not null,
0009 file varchar(128) not null,
0010 referer varchar(128) not null,
0011 agent varchar(128) not null);
0012
0013 LOAD DATA LOCAL INFILE '/etc/httpd/logs/access_log'
0014 INTO TABLE test.access_log
0015 FIELDS TERMINATED BY ','
0016 OPTIONALLY ENCLOSED BY '"'
0017 ESCAPED BY '\\';
