LOAD DATA
INFILE *
INTO TABLE connection_orientations
REPLACE
FIELDS TERMINATED BY '|'
(
description
,code
)
BEGINDATA
Vertical Up|VERTICAL UP
Vertical Down|VERTICAL DOWN
Horizontal Left|HORIZONTAL LEFT
Horizontal Right|HORIZONTAL RIGHT
Horizontal Back|HORIZONTAL BACK
Horizontal Front|HORIZONTAL FRONT