LOAD DATA
INFILE *
INTO TABLE bypass_reasons
REPLACE
FIELDS TERMINATED BY '|'
(
code
,description
)
BEGINDATA
4|Essential (Hospital, Prison, etc.)
5|Institutionalised Accomodation
2|Animal welfare
6|Manufacturing process requirement
3|Complicated pipework system
7|Please enter other reason for bypass
1|Not required