LOAD DATA
INFILE *
INTO TABLE party_relationship_types
REPLACE
FIELDS TERMINATED BY '|'
(
to_rt_code
,from_rt_code
,description
)
BEGINDATA
SUPP|AGENT|Agent for Service Supplier
SUPP|SUPPADMIN|Administrator for Supplier
AGENT|SUPPADMIN|Administrator of agent
SUPPADMIN|AGENT|Administered by