LOAD DATA
INFILE *
INTO TABLE relief_valves
REPLACE
FIELDS TERMINATED BY '|'
(
code
,rvty_code
,relief_valve_size
,relief_valve_setting
)
BEGINDATA
INTEGRAL-15|INTEGRAL|15|35
10L-25|10L|25|35
VS811-25|VS811|25|35
BADDATA|BADDATA|999|999