Skip to content

Instantly share code, notes, and snippets.

@ersin-demirtas
Created December 2, 2018 13:04
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ersin-demirtas/a38b0d26f2ab8832a53585b0ed657280 to your computer and use it in GitHub Desktop.
Save ersin-demirtas/a38b0d26f2ab8832a53585b0ed657280 to your computer and use it in GitHub Desktop.
INSERT INTO `states` (`name_long`, `name_short`, `created_at`) VALUES
('Alabama', 'AL', now()),
('Alaska', 'AK', now()),
('Arizona', 'AZ', now()),
('Arkansas', 'AR', now()),
('California', 'CA', now()),
('Colorado', 'CO', now()),
('Connecticut', 'CT', now()),
('Delaware', 'DE', now()),
('Florida', 'FL', now()),
('Georgia', 'GA', now()),
('Hawaii', 'HI', now()),
('Idaho', 'ID', now()),
('Illinois', 'IL', now()),
('Indiana', 'IN', now()),
('Iowa', 'IA', now()),
('Kansas', 'KS', now()),
('Kentucky', 'KY', now()),
('Louisiana', 'LA', now()),
('Maine', 'ME', now()),
('Maryland', 'MD', now()),
('Massachusetts', 'MA', now()),
('Michigan', 'MI', now()),
('Minnesota', 'MN', now()),
('Mississippi', 'MS', now()),
('Missouri', 'MO', now()),
('Montana', 'MT', now()),
('Nebraska', 'NE', now()),
('Nevada', 'NV', now()),
('New Hampshire', 'NH', now()),
('New Jersey', 'NJ', now()),
('New Mexico', 'NM', now()),
('New York', 'NY', now()),
('North Carolina', 'NC', now()),
('North Dakota', 'ND', now()),
('Ohio', 'OH', now()),
('Oklahoma', 'OK', now()),
('Oregon', 'OR', now()),
('Pennsylvania', 'PA', now()),
('Rhode Island', 'RI', now()),
('South Carolina', 'SC', now()),
('South Dakota', 'SD', now()),
('Tennessee', 'TN', now()),
('Texas', 'TX', now()),
('Utah', 'UT', now()),
('Vermont', 'VT', now()),
('Virginia', 'VA', now()),
('Washington', 'WA', now()),
('West Virginia', 'WV', now()),
('Wisconsin', 'WI', now()),
('Wyoming', 'WY', now());
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment