Very Useful US State Names and Abbreviations Database
April 27th, 2008 by 
cashvolume
Here is a very useful mysql database that includes U.S. state names with their abbreviations you can download it in plain text here. Just load up phpMyAdmin and import it into a new database. I found this very useful for making dating/personals websites without having to manually enter all the state names into individual tables. Here is how the database is setup:
#State names and abbreviations mysql database
#http://www.cashvolume.com
#
drop table if exists state;
create table state
(
state_id smallint unsigned not null auto_increment comment ‘Unique state ID’,
state varchar(32) not null comment ‘State name’,
state_abbr varchar(8) comment ‘State abbreviation’,
primary key (state_id)
);
insert into state
values
(NULL, ‘Alabama’, ‘AL’),
(NULL, ‘Alaska’, ‘AK’),
(NULL, ‘Arizona’, ‘AZ’),
(NULL, ‘Arkansas’, ‘AR’),
(NULL, ‘California’, ‘CA’),
(NULL, ‘Colorado’, ‘CO’),
(NULL, ‘Connecticut’, ‘CT’),
(NULL, ‘Delaware’, ‘DE’),
(NULL, ‘District of Columbia’, ‘DC’),
(NULL, ‘Florida’, ‘FL’),
(NULL, ‘Georgia’, ‘GA’),
Posted in mySQL | 
No Comments »