Canada Provinces SQL

Are you looking for Canada Provinces SQL. Here you go.

--
-- Create table `canadian_provinces`
--
CREATE TABLE `canadian_provinces` (
`id` int(11) NOT NULL auto_increment,
`state` varchar(200) NOT NULL,
`abbreviation` varchar(200) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

-- Insert data
INSERT INTO `canadian_provinces` (`id`, `state`, `abbreviation`)
VALUES (1, 'Alberta', 'AB'),
(2, 'British Columbia', 'BC'),
(3, 'Manitoba', 'MB'),
(4, 'New Brunswick', 'NB'),
(5, 'Newfoundland and Labrador', 'NL'),
(6, 'Northwest Territories', 'NT'),
(7, 'Nova Scotia', 'NS'),
(8, 'Nunavut', 'NU'),
(9, 'Ontario', 'ON'),
(10, 'Prince Edward Island', 'PE'),
(11, 'Québec', 'QC'),
(12, 'Saskatchewan', 'SK'),
(13, 'Yukon Territory', 'YT');