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') ; |
