SELECT
        id,
        trucking_abbr_name as disp_name,
        id as disp_sort,
        trucking_name as j_name,
        NULL as e_name,
        NULL as kana_name,
        NULL as note,
        0 as invalid_flag_code,
        NULL as deleted_at,
        NOW() as created_at,
        NOW() as updated_at
FROM truckings
INTO OUTFILE "/tmp/truckings.csv" FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"';
