I am trying to load data using the following sql, but always getting error as "field separator argument is not what is expected". Can anyone help to tell what is wrong with my sql?
Thank you in advance.
load data local infile 'C:/RxNorm_full_04012013/rrf/RXNATOMARCHIVE.RRF' into table RXNATOMARCHIVE
FIELDS TERMINATED BY '|' ESCAPED BY 'ä'
lines terminated by '\n