· 8 years ago · May 04, 2018, 06:02 AM
1
2
3# Dump of table states
4# ------------------------------------------------------------
5
6DROP TABLE IF EXISTS `states`;
7
8CREATE TABLE `states` (
9 `abbreviation` varchar(2) NOT NULL,
10 `name` varchar(20) DEFAULT NULL,
11 PRIMARY KEY (`abbreviation`)
12) ENGINE=MyISAM DEFAULT CHARSET=latin1;
13
14LOCK TABLES `states` WRITE;
15/*!40000 ALTER TABLE `states` DISABLE KEYS */;
16INSERT INTO `states` (`abbreviation`,`name`)
17VALUES
18 ('AL','Alabama'),
19 ('AK','Alaska'),
20 ('AZ','Arizona'),
21 ('AR','Arkansas'),
22 ('CA','California'),
23 ('CO','Colorado'),
24 ('CT','Connecticut'),
25 ('DE','Delaware'),
26 ('FL','Florida'),
27 ('GA','Georgia'),
28 ('HI','Hawaii'),
29 ('ID','Idaho'),
30 ('IL','Illinois'),
31 ('IN','Indiana'),
32 ('IA','Iowa'),
33 ('KS','Kansas'),
34 ('KY','Kentucky'),
35 ('LA','Louisiana'),
36 ('ME','Maine'),
37 ('MD','Maryland'),
38 ('MA','Massachusetts'),
39 ('MI','Michigan'),
40 ('MN','Minnesota'),
41 ('MS','Mississippi'),
42 ('MO','Missouri'),
43 ('MT','Montana'),
44 ('NE','Nebraska'),
45 ('NV','Nevada'),
46 ('NH','New Hampshire'),
47 ('NJ','New Jersey'),
48 ('NM','New Mexico'),
49 ('NY','New York'),
50 ('NC','North Carolina'),
51 ('ND','North Dakota'),
52 ('OH','Ohio'),
53 ('OK','Oklahoma'),
54 ('OR','Oregon'),
55 ('PA','Pennsylvania'),
56 ('RI','Rhode Island'),
57 ('SC','South Carolina'),
58 ('SD','South Dakota'),
59 ('TN','Tennessee'),
60 ('TX','Texas'),
61 ('UT','Utah'),
62 ('VT','Vermont'),
63 ('VA','Virginia'),
64 ('WA','Washington'),
65 ('WV','West Virginia'),
66 ('WI','Wisconsin'),
67 ('WY','Wyoming'),
68 ('DC','District of Columbia');