select id as id,
       disp_name as disp_name,
       id as disp_sort,
       j_name as j_name,
       e_name as e_name,
       NULL as kana_name,
       NULL as note,
       IF(deleted_at is NULL, 0, 1) as invalid_flag_code,
       NULL as deleted_at,
       created_at as created_at,
       updated_at as updated_at
FROM truckings
INTO OUTFILE "/tmp/truckings.csv" FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\';
