LOAD DATA
INFILE *
INTO TABLE meter_size_codes
REPLACE
FIELDS TERMINATED BY '|'
TRAILING NULLCOLS
(
code
,description
,qmax
,valid_for_existing_meter
,valid_for_new_meter
)
BEGINDATA
U16|U16|173|YES|YES
U25|U25|270|YES|YES
U40|U40|432|YES|YES
U65|U65|701|YES|YES
U100|U100|1068|YES|YES
U160|U160|1468|YES|YES
OTHER|Other Meter Size|0|YES|YES
40MM|40mm|0|YES|NO
50MM|50mm|0|YES|NO
80MM|80mm|0|YES|NO
100MM|100mm|0|YES|NO
150MM|150mm|0|YES|NO
200MM|200mm|0|YES|NO
250MM|250mm|0|YES|NO