advanced code snippet search

Posted By

misteroneill on 08/23/09


Tagged

states us usa United Territories


Versions (?)

Who likes this?

3 people have marked this snippet as a favorite

dantreacy
kubaitis
virendrakryadav


United States and Territories

 / Published in: MySQL
 

URL: http://www.misteroneill.com

This creates a table of the states in the US as well as territories.

Expand | Embed | Plain Text 
  1. CREATE TABLE IF NOT EXISTS us_states (
  2. 	id INT NOT NULL AUTO_INCREMENT,
  3. 	name CHAR(40) NOT NULL,
  4. 	abbrev CHAR(2) NOT NULL,
  5. 	PRIMARY KEY (id)
  6. );
  7.  
  8. INSERT INTO us_states VALUES (NULL, 'Alaska', 'AK');
  9. INSERT INTO us_states VALUES (NULL, 'Alabama', 'AL');
  10. INSERT INTO us_states VALUES (NULL, 'American Samoa', 'AS');
  11. INSERT INTO us_states VALUES (NULL, 'Arizona', 'AZ');
  12. INSERT INTO us_states VALUES (NULL, 'Arkansas', 'AR');
  13. INSERT INTO us_states VALUES (NULL, 'California', 'CA');
  14. INSERT INTO us_states VALUES (NULL, 'Colorado', 'CO');
  15. INSERT INTO us_states VALUES (NULL, 'Connecticut', 'CT');
  16. INSERT INTO us_states VALUES (NULL, 'Delaware', 'DE');
  17. INSERT INTO us_states VALUES (NULL, 'District of Columbia', 'DC');
  18. INSERT INTO us_states VALUES (NULL, 'Federated States of Micronesia', 'FM');
  19. INSERT INTO us_states VALUES (NULL, 'Florida', 'FL');
  20. INSERT INTO us_states VALUES (NULL, 'Georgia', 'GA');
  21. INSERT INTO us_states VALUES (NULL, 'Guam', 'GU');
  22. INSERT INTO us_states VALUES (NULL, 'Hawaii', 'HI');
  23. INSERT INTO us_states VALUES (NULL, 'Idaho', 'ID');
  24. INSERT INTO us_states VALUES (NULL, 'Illinois', 'IL');
  25. INSERT INTO us_states VALUES (NULL, 'Indiana', 'IN');
  26. INSERT INTO us_states VALUES (NULL, 'Iowa', 'IA');
  27. INSERT INTO us_states VALUES (NULL, 'Kansas', 'KS');
  28. INSERT INTO us_states VALUES (NULL, 'Kentucky', 'KY');
  29. INSERT INTO us_states VALUES (NULL, 'Louisiana', 'LA');
  30. INSERT INTO us_states VALUES (NULL, 'Maine', 'ME');
  31. INSERT INTO us_states VALUES (NULL, 'Marshall Islands', 'MH');
  32. INSERT INTO us_states VALUES (NULL, 'Maryland', 'MD');
  33. INSERT INTO us_states VALUES (NULL, 'Massachusetts', 'MA');
  34. INSERT INTO us_states VALUES (NULL, 'Michigan', 'MI');
  35. INSERT INTO us_states VALUES (NULL, 'Minnesota', 'MN');
  36. INSERT INTO us_states VALUES (NULL, 'Mississippi', 'MS');
  37. INSERT INTO us_states VALUES (NULL, 'Missouri', 'MO');
  38. INSERT INTO us_states VALUES (NULL, 'Montana', 'MT');
  39. INSERT INTO us_states VALUES (NULL, 'Nebraska', 'NE');
  40. INSERT INTO us_states VALUES (NULL, 'Nevada', 'NV');
  41. INSERT INTO us_states VALUES (NULL, 'New Hampshire', 'NH');
  42. INSERT INTO us_states VALUES (NULL, 'New Jersey', 'NJ');
  43. INSERT INTO us_states VALUES (NULL, 'New Mexico', 'NM');
  44. INSERT INTO us_states VALUES (NULL, 'New York', 'NY');
  45. INSERT INTO us_states VALUES (NULL, 'North Carolina', 'NC');
  46. INSERT INTO us_states VALUES (NULL, 'North Dakota', 'ND');
  47. INSERT INTO us_states VALUES (NULL, 'Northern Mariana Islands', 'MP');
  48. INSERT INTO us_states VALUES (NULL, 'Ohio', 'OH');
  49. INSERT INTO us_states VALUES (NULL, 'Oklahoma', 'OK');
  50. INSERT INTO us_states VALUES (NULL, 'Oregon', 'OR');
  51. INSERT INTO us_states VALUES (NULL, 'Palau', 'PW');
  52. INSERT INTO us_states VALUES (NULL, 'Pennsylvania', 'PA');
  53. INSERT INTO us_states VALUES (NULL, 'Puerto Rico', 'PR');
  54. INSERT INTO us_states VALUES (NULL, 'Rhode Island', 'RI');
  55. INSERT INTO us_states VALUES (NULL, 'South Carolina', 'SC');
  56. INSERT INTO us_states VALUES (NULL, 'South Dakota', 'SD');
  57. INSERT INTO us_states VALUES (NULL, 'Tennessee', 'TN');
  58. INSERT INTO us_states VALUES (NULL, 'Texas', 'TX');
  59. INSERT INTO us_states VALUES (NULL, 'Utah', 'UT');
  60. INSERT INTO us_states VALUES (NULL, 'Vermont', 'VT');
  61. INSERT INTO us_states VALUES (NULL, 'Virgin Islands', 'VI');
  62. INSERT INTO us_states VALUES (NULL, 'Virginia', 'VA');
  63. INSERT INTO us_states VALUES (NULL, 'Washington', 'WA');
  64. INSERT INTO us_states VALUES (NULL, 'West Virginia', 'WV');
  65. INSERT INTO us_states VALUES (NULL, 'Wisconsin', 'WI');
  66. INSERT INTO us_states VALUES (NULL, 'Wyoming', 'WY');
  67. INSERT INTO us_states VALUES (NULL, 'Armed Forces Africa', 'AE');
  68. INSERT INTO us_states VALUES (NULL, 'Armed Forces Americas (except Canada)', 'AA');
  69. INSERT INTO us_states VALUES (NULL, 'Armed Forces Canada', 'AE');
  70. INSERT INTO us_states VALUES (NULL, 'Armed Forces Europe', 'AE');
  71. INSERT INTO us_states VALUES (NULL, 'Armed Forces Middle East', 'AE');
  72. INSERT INTO us_states VALUES (NULL, 'Armed Forces Pacific', 'AP');

Report this snippet  

You need to login to post a comment.