select id as id,
       bank_code as bank_number,
       j_bank_name as disp_name,
       id as disp_sort,
       j_bank_name as j_name,
       e_bank_name 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 banks
INTO OUTFILE "/tmp/banks.csv" FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"';
