list of states of canada (MySQL Table)

MySQL Table for states of canada

 

CREATE TABLE IF NOT EXISTS `states_of_canada` (
  `id` bigint(20) NOT NULL auto_increment,
  `name` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ;

 

INSERT INTO `states_of_canada` (`id`, `name`) VALUES
(1, 'Alberta'),
(2, 'British Columbia'),
(3, 'Manitoba'),
(4, 'New Brunswick'),
(5, 'Newfoundland'),
(6, 'Northwest Territory'),
(7, 'Nova Scotia'),
(8, 'Nunavut'),
(9, 'Ontario'),
(10, 'Prince Edward Island'),
(11, 'Quebec'),
(12, 'Saskatchewan'),
(13, 'Yukon Territory');