MySQL Canada Provinces Territories


/ Published in: MySQL
Save to your folder(s)



Copy this code and paste it in your HTML
  1. # This will create and then populate a MySQL table with a list of the names and
  2. # ISO code abbreviations for the provinces and territories of Canada.
  3.  
  4.  
  5. CREATE TABLE `ca_provinces` (
  6. `name` VARCHAR( 255 ) NOT NULL ,
  7. `iso` CHAR( 2 ) NOT NULL
  8. );
  9.  
  10. INSERT INTO `ca_provinces` (`id`, `name`, `iso`)
  11. (NULL, 'Alberta', 'AB'),
  12. (NULL, 'British Columbia', 'BC'),
  13. (NULL, 'Manitoba', 'MB'),
  14. (NULL, 'New Brunswick', 'NB'),
  15. (NULL, 'Newfoundland and Labrador', 'NL'),
  16. (NULL, 'Northwest Territories', 'NT'),
  17. (NULL, 'Nova Scotia', 'NS'),
  18. (NULL, 'Nunavut', 'NU'),
  19. (NULL, 'Ontario', 'ON'),
  20. (NULL, 'Prince Edward Island', 'PE'),
  21. (NULL, 'Quebec', 'QC'),
  22. (NULL, 'Saskatchewan', 'SK'),
  23. (NULL, 'Yukon', 'YT');

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.