Canadian Provinces in MySQL Table
I posted a list of U.S. State Abbreviations up here a while ago, then found myself needing the Canadian provinces as well. Here's the MySQL code to easily create a table of abbreviations and names. Hope it saves you some time!
CREATE TABLE `canada` (
`name` VARCHAR( 26 ) NOT NULL ,
`abv` CHAR( 2 ) NOT NULL ,
PRIMARY KEY ( `abv` )
);
INSERT INTO `canada` VALUES ('Alberta', 'AB');
INSERT INTO `canada` VALUES ('British Columbia', 'BC');
INSERT INTO `canada` VALUES ('Manitoba', 'MB');
INSERT INTO `canada` VALUES ('New Brunswick', 'NB');
INSERT INTO `canada` VALUES ('Newfoundland and Labrador', 'NL');
INSERT INTO `canada` VALUES ('Northwest Territories', 'NT');
INSERT INTO `canada` VALUES ('Nova Scotia', 'NS');
INSERT INTO `canada` VALUES ('Nunavut', 'NU');
INSERT INTO `canada` VALUES ('Ontario', 'ON');
INSERT INTO `canada` VALUES ('Prince Edward Island', 'PE');
INSERT INTO `canada` VALUES ('Quebec', 'QC');
INSERT INTO `canada` VALUES ('Saskatchewan', 'SK');
INSERT INTO `canada` VALUES ('Yukon', 'YT');