Control File

load data
infile *
into table table_name
Append
fields terminated by '|' optionally enclosed by '"' TRAILING NULLCOLS
(
field 1 ,
field 2 ,
field 3 ,
)