LOAD DATA
INFILE *
INTO TABLE meters
REPLACE
FIELDS TERMINATED BY '|'
(
code
,drwg_code
,mety_code
,prty_id
,dim_a
,dim_b
,centres
,dim_c
,weight
,qmax
,valid_from
,valid_to
,qnom
,qmin
)
BEGINDATA
MRA25A||ROTARY|100|121|96|0|159|2.7|25|13-FEB-07||25|1.3
MRA40A||ROTARY|100|121|96|0|189|3.4|40|13-FEB-07||40|2
MRA65B||ROTARY|100|171|96|0|307|3.4|65|13-FEB-07||65|2
MRA100B||ROTARY|100|171|182|0|307|11|100|13-FEB-07||92.53|5
MRA160C||ROTARY|100|171|182|0|382|15|160|13-FEB-07||160|8
MRA200C||ROTARY|100|171|182|0|428|17|200|13-FEB-07||187.79|10
MRA250C||ROTARY|100|241|235|0|409|29|250|13-FEB-07||201.91|12.5
MRA300D||ROTARY|100|241|235|0|479|34|300|13-FEB-07||264.69|15
MRA400D||ROTARY|100|241|235|0|615|43|400|13-FEB-07||329.15|20
MRA650E||ROTARY|100|450|308|0|665|104|650|13-FEB-07||534.87|32.5
MRA1000E||ROTARY|100|500|400|0|820|197|1000|13-FEB-07||666.4|50
MRD0025B4B||ROTARY|101|171|152|0|316|8|25|13-FEB-07||25|1.25
MRD0040B4B||ROTARY|101|171|152|0|353|10|40|13-FEB-07||40|2
MRD0065B4B||ROTARY|101|171|177|0|357|12|65|13-FEB-07||57|3.25
MRD0100B4B||ROTARY|101|171|177|0|388|14|100|13-FEB-07||81|5
MRD0160B4C||ROTARY|101|171|177|0|460|17|160|13-FEB-07||130|8
MRD0250B4D||ROTARY|101|241|226|0|485|28|250|13-FEB-07||230|12.5
MRD0310B4D||ROTARY|101|241|226|0|502|29|310|13-FEB-07||285|15.5
MRD0450B4D||ROTARY|101|241|226|0|620|38|450|13-FEB-07||362|22.5
MRD0650B4E||ROTARY|101|406|457|0|684|94|650|13-FEB-07||547|32.5
MRD1075B4E||ROTARY|101|533|457|0|822|116|1075|13-FEB-07||710|54
MRD2885B4F||ROTARY|101|711|754|0|1295|1055|2885|13-FEB-07||2137|144
MDA16||DIAPHRAGM|100|0|0|0|0|0|16|13-FEB-07||16|.8
MDA25||DIAPHRAGM|100|0|0|0|0|0|25|13-FEB-07||25|1.25
MDA40||DIAPHRAGM|100|0|0|0|0|0|40|13-FEB-07||40|2
MDA65||DIAPHRAGM|100|0|0|0|0|0|65|13-FEB-07||65|3.25
MDA100||DIAPHRAGM|100|0|0|0|0|0|100|13-FEB-07||99|5
MDA160||DIAPHRAGM|100|0|0|0|0|0|160|13-FEB-07||136|8
MRD1600B4F||ROTARY|101|533|457|0|922|284|1600|13-FEB-07||1181|80