LOAD DATA
INFILE *
INTO TABLE meter_types
REPLACE
FIELDS TERMINATED BY '|'
(
code
,description
)
BEGINDATA
ROTARY|Rotary
TURBINE|Turbine
ORIFICE|Orifice
ULTRASONIC|Ultrasonic flow
DIAPHRAGM|Diaphragm
CORIOLIS|Coriolis