LOAD DATA
INFILE *
INTO TABLE connection_types
REPLACE
FIELDS TERMINATED BY '|'
(
code
,description
)
BEGINDATA
BADDATA|BAD DATA
(MM) BSPT|(mm) BSPT
(MM) PN16|(mm) PN16
INCH BS 746|INCH BS 746