load data local infile '_FILENAME_' into table flightstats
fields terminated by ',' optionally enclosed by '"'
ignore 1 lines
(
@Year, @Quarter, @Month,
AirlineID, UniqueCarrier, Carrier, FlightDate,
@DayofMonth, @DayOfWeek, @Flights,
FlightNum, TailNum,
@ActualElapsedTime, @CRSElapsedTime, @AirTime, @ArrDel15, @ArrDel30, @ArrDelSys15,
@ArrDelSys30, @ArrDelay, @ArrTime, @ArrTimeBlk, @CRSArrTime, @DepDel15, @DepDel30,
@DepDelSys15, @DepDelSys30, @DepDelay, @DepTime, @DepTimeBlk, @CRSDepTime,
Origin,
@OriginCityName, @OriginState, @OriginStateFips, @OriginStateName, @OriginWac,
Dest,
@DestCityName, @DestState, @DestStateFips, @DestStateName, @DestWac,
Distance,
@DistanceGroup, @TaxiIn, @TaxiOut, @WheelsOff, @WheelsOn, @Cancelled, 
@CancellationCode, @Diverted, @CarrierDelay, @WeatherDelay, @NASDelay,
@SecurityDelay, @LateAircraftDelay)
SET ArrTime = concat(FlightDate, ' ', left(@ArrTime,2), ':', right(@ArrTime,2), ':00'),
    DepTime = concat(FlightDate, ' ', left(@DepTime,2), ':', right(@DepTime,2), ':00'),
    Cancelled=if(@Cancelled != 'n' and @Cancelled != 'y', 'n', @Cancelled),
    ArrDelay = if(@ArrDelay is null or @ArrDelay ="", 0, @ArrDelay),
    DepDelay = if(@DepDelay is null or @DepDelay ="", 0, @DepDelay)
;
show warnings;