· 4 years ago · Jan 22, 2021, 03:40 PM
1#CREATE DATABASE IF NOT EXISTS `zipcode`;
2#USE `zipcode`;
3#
4#
5# Table structure for table 'postcodes'
6#
7
8DROP TABLE IF EXISTS `postcodes`;
9
10CREATE TABLE `postcodes` (
11 `Postcode` VARCHAR(8) NOT NULL,
12 PRIMARY KEY (`Postcode`)
13) ENGINE=myisam DEFAULT CHARSET=utf8;
14
15SET autocommit=1;
16
17#
18# Dumping data for table 'postcodes'
19#
20
21INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0AA');
22INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0AB');
23INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0AD');
24INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0AE');
25INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0AF');
26INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0AG');
27INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0AJ');
28INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0AL');
29INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0AN');
30INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0AP');
31INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0AQ');
32INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0AR');
33INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0AS');
34INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0AT');
35INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0AX');
36INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0BA');
37INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0BB');
38INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0BD');
39INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0BE');
40INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0BJ');
41INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0BL');
42INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0BN');
43INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0BP');
44INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0BQ');
45INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0BR');
46INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0BS');
47INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0BT');
48INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0BX');
49INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0BY');
50INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0BZ');
51INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0DA');
52INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0DB');
53INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0DD');
54INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0DJ');
55INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0DL');
56INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0DN');
57INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0DP');
58INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0DQ');
59INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0DR');
60INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0DS');
61INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0DT');
62INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0DU');
63INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0DX');
64INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0DY');
65INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0EA');
66INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0EB');
67INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0ED');
68INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0EE');
69INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0EF');
70INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0EH');
71INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0EJ');
72INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0EL');
73INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0EN');
74INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0EP');
75INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0EQ');
76INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0ER');
77INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0ES');
78INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0ET');
79INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0EU');
80INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0EW');
81INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0EX');
82INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0HA');
83INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0HB');
84INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0HD');
85INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0HJ');
86INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0HL');
87INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0HN');
88INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0HP');
89INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0HQ');
90INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0HR');
91INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0HS');
92INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0HT');
93INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0HU');
94INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0HX');
95INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0JA');
96INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0JB');
97INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0JD');
98INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0JE');
99INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0JG');
100INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0JH');
101INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0JJ');
102INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0JL');
103INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0JN');
104INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0JP');
105INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0JQ');
106INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0JR');
107INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0JS');
108INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0JT');
109INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0JU');
110INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0JW');
111INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0JX');
112INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0JY');
113INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0JZ');
114INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0LA');
115INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0LB');
116INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0LD');
117INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0LE');
118INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0LJ');
119INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0LL');
120INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0LN');
121INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0LP');
122INSERT INTO `postcodes` (`Postcode`) VALUES ('AB1 0LQ');