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