I recently posted a Canadian Provinces MySQL script, I had also done the US States. I had found a MySQL country script too and cleaned it up adding country_name, which is cleanly formatted.
Now you can download all of these sql scripts.
Enjoy
I always find these things useful, I also have the US States if you need those.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 | CREATE TABLE provinces ( province_id smallint NOT NULL AUTO_INCREMENT PRIMARY KEY, province varchar(50) NOT NULL, province_abbr varchar(2) NOT NULL )ENGINE=InnoDB, COLLATE=utf8_general_ci; INSERT INTO provinces VALUES (NULL, 'Alberta', 'AB'), (NULL, 'British Columbia', 'BC'), (NULL, 'Manitoba', 'MB'), (NULL, 'New Brunswick', 'NB'), (NULL, 'Newfoundland and Labrador', 'NL'), (NULL, 'Northwest Territories', 'NT'), (NULL, 'Nova Scotia', 'NS'), (NULL, 'Nunavut', 'NU'), (NULL, 'Ontario', 'ON'), (NULL, 'Prince Edward Island', 'PE'), (NULL, 'Quebec', 'QC'), (NULL, 'Saskatchewan', 'SK'), (NULL, 'Yukon', 'YT') ; |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 | CREATE TABLE states ( state_id smallint NOT NULL AUTO_INCREMENT PRIMARY KEY, state varchar(50) NOT NULL, state_abbr varchar(2) NOT NULL )ENGINE=InnoDB, COLLATE=utf8_general_ci; INSERT INTO states VALUES (NULL, 'Alabama', 'AL'), (NULL, 'Alaska', 'AK'), (NULL, 'Arizona', 'AZ'), (NULL, 'Arkansas', 'AR'), (NULL, 'California', 'CA'), (NULL, 'Colorado', 'CO'), (NULL, 'Connecticut', 'CT'), (NULL, 'Delaware', 'DE'), (NULL, 'District of Columbia', 'DC'), (NULL, 'Florida', 'FL'), (NULL, 'Georgia', 'GA'), (NULL, 'Hawaii', 'HI'), (NULL, 'Idaho', 'ID'), (NULL, 'Illinois', 'IL'), (NULL, 'Indiana', 'IN'), (NULL, 'Iowa', 'IA'), (NULL, 'Kansas', 'KS'), (NULL, 'Kentucky', 'KY'), (NULL, 'Louisiana', 'LA'), (NULL, 'Maine', 'ME'), (NULL, 'Maryland', 'MD'), (NULL, 'Massachusetts', 'MA'), (NULL, 'Michigan', 'MI'), (NULL, 'Minnesota', 'MN'), (NULL, 'Mississippi', 'MS'), (NULL, 'Missouri', 'MO'), (NULL, 'Montana', 'MT'), (NULL, 'Nebraska', 'NE'), (NULL, 'Nevada', 'NV'), (NULL, 'New Hampshire', 'NH'), (NULL, 'New Jersey', 'NJ'), (NULL, 'New Mexico', 'NM'), (NULL, 'New York', 'NY'), (NULL, 'North Carolina', 'NC'), (NULL, 'North Dakota', 'ND'), (NULL, 'Ohio', 'OH'), (NULL, 'Oklahoma', 'OK'), (NULL, 'Oregon', 'OR'), (NULL, 'Pennsylvania', 'PA'), (NULL, 'Rhode Island', 'RI'), (NULL, 'South Carolina', 'SC'), (NULL, 'South Dakota', 'SD'), (NULL, 'Tennessee', 'TN'), (NULL, 'Texas', 'TX'), (NULL, 'Utah', 'UT'), (NULL, 'Vermont', 'VT'), (NULL, 'Virginia', 'VA'), (NULL, 'Washington', 'WA'), (NULL, 'West Virginia', 'WV'), (NULL, 'Wisconsin', 'WI'), (NULL, 'Wyoming', 'WY') ; |
