LOAD DATA
INFILE *
INTO TABLE contact_mechanism_types
REPLACE
FIELDS TERMINATED BY '|'
(
code
,description
)
BEGINDATA
FAX|Fax
PHONE|Telephone
MOBILE|Mobile
EMAIL|Email