LOAD DATA
INFILE *
INTO TABLE drawings
REPLACE
FIELDS TERMINATED BY '|'
(
code
,description
)
BEGINDATA
BADDATA|MISSING DRAWING
C|BASE
H|BASE
HH|BASE
HVO|BASE
LO|HOUSING
lphhcompac|MODULE
lphhstd|MODULE
lpvhcompac|MODULE
lpvvcom25|MODULE
lpvvcom40|MODULE
lpvvcompac|MODULE
lpvvstddia|MODULE
mpvvlooprot|MODULE
mpvvstddia|MODULE
mpvvstdrot|MODULE
VH|BASE
WI|HOUSING