Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DROP TABLE IF EXISTS states;
- CREATE TABLE states
- (
- id SMALLINT NOT NULL AUTO_INCREMENT comment 'PK: Unique state ID',
- state VARCHAR(32) NOT NULL comment 'State name with first letter capital',
- state_abbr VARCHAR(8) comment 'Optional state abbreviation (US is 2 capital letters)',
- PRIMARY KEY (id)
- );
- INSERT INTO states (state, state_abbr) VALUES
- ('Alabama', 'AL'),
- ('Alaska', 'AK'),
- ('Arizona', 'AZ'),
- ('Arkansas', 'AR'),
- ('California', 'CA'),
- ('Colorado', 'CO'),
- ('Connecticut', 'CT'),
- ('Delaware', 'DE'),
- ('District of Columbia', 'DC'),
- ('Florida', 'FL'),
- ('Georgia', 'GA'),
- ('Hawaii', 'HI'),
- ('Idaho', 'ID'),
- ('Illinois', 'IL'),
- ('Indiana', 'IN'),
- ('Iowa', 'IA'),
- ('Kansas', 'KS'),
- ('Kentucky', 'KY'),
- ('Louisiana', 'LA'),
- ('Maine', 'ME'),
- ('Maryland', 'MD'),
- ('Massachusetts', 'MA'),
- ('Michigan', 'MI'),
- ('Minnesota', 'MN'),
- ('Mississippi', 'MS'),
- ('Missouri', 'MO'),
- ('Montana', 'MT'),
- ('Nebraska', 'NE'),
- ('Nevada', 'NV'),
- ('New Hampshire', 'NH'),
- ('New Jersey', 'NJ'),
- ('New Mexico', 'NM'),
- ('New York', 'NY'),
- ('North Carolina', 'NC'),
- ('North Dakota', 'ND'),
- ('Ohio', 'OH'),
- ('Oklahoma', 'OK'),
- ('Oregon', 'OR'),
- ('Pennsylvania', 'PA'),
- ('Rhode Island', 'RI'),
- ('South Carolina', 'SC'),
- ('South Dakota', 'SD'),
- ('Tennessee', 'TN'),
- ('Texas', 'TX'),
- ('Utah', 'UT'),
- ('Vermont', 'VT'),
- ('Virginia', 'VA'),
- ('Washington', 'WA'),
- ('West Virginia', 'WV'),
- ('Wisconsin', 'WI'),
- ('Wyoming', 'WY')
- ;
Add Comment
Please, Sign In to add comment