LOAD DATA
INFILE *
INTO TABLE asset_location_types
REPLACE
FIELDS TERMINATED BY '|'
(
code
,description
)
BEGINDATA
00|Unknown
01|Cellar
02|Under Stairs
03|Hall
04|Kitchen
05|Bathroom
06|Garage
07|Canteen
08|Cloakroom
09|Cupboard
10|Domestic Science
11|Front Door
12|Hall Cupboard
13|Kitchen Cupboard
14|Kitchen under sink
15|Landing
16|Office
17|Office Cupboard
18|Outside WC
19|Pantry
20|Porch
21|Public Bar
22|Rear of Shop
23|Saloon Bar
24|Shed
25|Shop Front
26|Shop Window
27|Staff Room
28|Store Room
29|Toilet
30|Under Counter
31|Waiting Room
32|Meter box Outside
98|Other
99|Outside