CREATE TABLE `b` (
  `Host` char(17) NOT NULL,
  `Date` date NOT NULL,
  `Time` time NOT NULL,
  `Request` text,
  `Status` smallint unsigned NOT NULL,
  `BytesSent` int unsigned NOT NULL,
  `Referer` text,
  `UserAgent` text,
  KEY `ATime_idx` (`Time`),
  KEY `Status_idx` (`Status`),
  KEY `Date_idx` (`Date`)
) ENGINE=MyISAM;


load data infile '/var/lib/mysql-files/1.log' into table b fields terminated by ' ' optionally enclosed by '"';