daily pastebin goal
2%
SHARE
TWEET

Untitled

a guest May 27th, 2018 64 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. DROP TABLE IF EXISTS states;
  2. CREATE TABLE states
  3. (
  4. id SMALLINT NOT NULL AUTO_INCREMENT comment 'PK: Unique state ID',
  5. state VARCHAR(32) NOT NULL comment 'State name with first letter capital',
  6. state_abbr VARCHAR(8) comment 'Optional state abbreviation (US is 2 capital letters)',
  7. PRIMARY KEY (id)
  8. );
  9.  
  10.  
  11. INSERT INTO states (state, state_abbr) VALUES
  12. ('Alabama', 'AL'),
  13. ('Alaska', 'AK'),
  14. ('Arizona', 'AZ'),
  15. ('Arkansas', 'AR'),
  16. ('California', 'CA'),
  17. ('Colorado', 'CO'),
  18. ('Connecticut', 'CT'),
  19. ('Delaware', 'DE'),
  20. ('District of Columbia', 'DC'),
  21. ('Florida', 'FL'),
  22. ('Georgia', 'GA'),
  23. ('Hawaii', 'HI'),
  24. ('Idaho', 'ID'),
  25. ('Illinois', 'IL'),
  26. ('Indiana', 'IN'),
  27. ('Iowa', 'IA'),
  28. ('Kansas', 'KS'),
  29. ('Kentucky', 'KY'),
  30. ('Louisiana', 'LA'),
  31. ('Maine', 'ME'),
  32. ('Maryland', 'MD'),
  33. ('Massachusetts', 'MA'),
  34. ('Michigan', 'MI'),
  35. ('Minnesota', 'MN'),
  36. ('Mississippi', 'MS'),
  37. ('Missouri', 'MO'),
  38. ('Montana', 'MT'),
  39. ('Nebraska', 'NE'),
  40. ('Nevada', 'NV'),
  41. ('New Hampshire', 'NH'),
  42. ('New Jersey', 'NJ'),
  43. ('New Mexico', 'NM'),
  44. ('New York', 'NY'),
  45. ('North Carolina', 'NC'),
  46. ('North Dakota', 'ND'),
  47. ('Ohio', 'OH'),
  48. ('Oklahoma', 'OK'),
  49. ('Oregon', 'OR'),
  50. ('Pennsylvania', 'PA'),
  51. ('Rhode Island', 'RI'),
  52. ('South Carolina', 'SC'),
  53. ('South Dakota', 'SD'),
  54. ('Tennessee', 'TN'),
  55. ('Texas', 'TX'),
  56. ('Utah', 'UT'),
  57. ('Vermont', 'VT'),
  58. ('Virginia', 'VA'),
  59. ('Washington', 'WA'),
  60. ('West Virginia', 'WV'),
  61. ('Wisconsin', 'WI'),
  62. ('Wyoming', 'WY')
  63. ;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Pastebin PRO 'SUMMER SPECIAL'!
Get 40% OFF Pastebin PRO accounts!
 
Top