9f9265194c
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3694 248e525c-4dfb-0310-94bc-949c084e9493
23 lines
745 B
Plaintext
23 lines
745 B
Plaintext
LOAD DATA
|
|
INFILE *
|
|
INTO TABLE regions
|
|
REPLACE
|
|
FIELDS TERMINATED BY '|'
|
|
TRAILING NULLCOLS
|
|
(
|
|
code
|
|
,description
|
|
,contact_text
|
|
,quotation_text
|
|
)
|
|
BEGINDATA
|
|
NETW01|Scotland|Scotia Gas Networks Ltd|Scotia Gas Networks Ltd
|
|
NETW02|Northern|Northern Gas Network Ltd|Northern Gas Network Ltd
|
|
NETW03|Southern|Scotia Gas Networks Ltd|Scotia Gas Networks Ltd
|
|
NETW04|Wales and West|Wales and West Utilities Ltd|Wales and West Utilities Ltd
|
|
NETW05|North West|National Grid Gas|National Grid Gas
|
|
NETW06|West Midlands|National Grid Gas|National Grid Gas
|
|
NETW07|East of England|National Grid Gas|National Grid Gas
|
|
NETW08|London|National Grid Gas|National Grid Gas
|
|
RDN01|Retained networks|National Grid Metering Ltd|National Grid Metering Ltd
|