PHP BASIC List of American States

 List of USA States

 

--

-- Table structure for table `states`

--

 

CREATE TABLE `states` (

  `abbreviation` varchar(2) NOT NULL,

  `state` text,

  PRIMARY KEY  (`abbreviation`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

--

-- Dumping data for table `states`

--

 

INSERT INTO `states` (`abbreviation`, `state`) VALUES

('AL', 'Alabama'),

('AK', 'Alaska'),

('AZ', 'Arizona'),

('AR', 'Arkansas'),

('CA', 'California'),

('CO', 'Colorado'),

('CT', 'Connecticut'),

('DE', 'Delaware'),

('FL', 'Florida'),

('GA', 'Georgia'),

('HI', 'Hawaii'),

('ID', 'Idaho'),

('IL', 'Illinois'),

('IN', 'Indiana'),

('IA', 'Iowa'),

('KS', 'Kansas'),

('KY', 'Kentucky'),

('LA', 'Louisiana'),

('ME', 'Maine'),

('MD', 'Maryland'),

('MA', 'Massachusetts'),

('MI', 'Michigan'),

('MN', 'Minnesota'),

('MS', 'Mississippi'),

('MO', 'Missouri'),

('MT', 'Montana'),

('NE', 'Nebraska'),

('NV', 'Nevada'),

('NH', 'New Hampshire'),

('NJ', 'New Jersey'),

('NM', 'New Mexico'),

('NY', 'New York'),

('NC', 'North Carolina'),

('ND', 'North Dakota'),

('OH', 'Ohio'),

('OK', 'Oklahoma'),

('OR', 'Oregon'),

('PA', 'Pennsylvania'),

('RI', 'Rhode Island'),

('SC', 'South Carolina'),

('SD', 'South Dakota'),

('TN', 'Tennessee'),

('TX', 'Texas'),

('UT', 'Utah'),

('VT', 'Vermont'),

('VA', 'Virginia'),

('WA', 'Washington'),

('WV', 'West Virginia'),

('WI', 'Wisconsin'),

('WY', 'Wyoming'),

('DC', 'District of Columbia');

Author: Vikas Agrawal

Vikas Agrawal is a CEO and Founder Of Vinayak Informatics Systems. Read More →