The Blog of Frank Spohr

If you ever need to insert the 50 United States of America into a MySQL database, here’s the SQL code to make your life a little easier.  All you’ll need to do is first create a table called states with the fields called id and state_name.

INSERT INTO `states` ( `id` , `state_name`) VALUES (NULL , 'Arkansas');
INSERT INTO `states` ( `id` , `state_name`) VALUES (NULL , 'California');
INSERT INTO `states` ( `id` , `state_name`) VALUES (NULL , 'Colorado');
INSERT INTO `states` ( `id` , `state_name`) VALUES (NULL , 'Connecticut');
INSERT INTO `states` ( `id` , `state_name`) VALUES (NULL , 'Delaware');
INSERT INTO `states` ( `id` , `state_name`) VALUES (NULL , 'District of Columbia');
INSERT INTO `states` ( `id` , `state_name`) VALUES (NULL , 'Florida');
INSERT INTO `states` ( `id` , `state_name`) VALUES (NULL , 'Georgia');
INSERT INTO `states` ( `id` , `state_name`) VALUES (NULL , 'Hawaii');
INSERT INTO `states` ( `id` , `state_name`) VALUES (NULL , 'Idaho');
INSERT INTO `states` ( `id` , `state_name`) VALUES (NULL , 'Illinois');
INSERT INTO `states` ( `id` , `state_name`) VALUES (NULL , 'Indiana');
INSERT INTO `states` ( `id` , `state_name`) VALUES (NULL , 'Iowa');
INSERT INTO `states` ( `id` , `state_name`) VALUES (NULL , 'Kansas');
INSERT INTO `states` ( `id` , `state_name`) VALUES (NULL , 'Kentucky');
INSERT INTO `states` ( `id` , `state_name`) VALUES (NULL , 'Louisiana');
INSERT INTO `states` ( `id` , `state_name`) VALUES (NULL , 'Maine');
INSERT INTO `states` ( `id` , `state_name`) VALUES (NULL , 'Maryland');
INSERT INTO `states` ( `id` , `state_name`) VALUES (NULL , 'Massachusetts');
INSERT INTO `states` ( `id` , `state_name`) VALUES (NULL , 'Michigan');
INSERT INTO `states` ( `id` , `state_name`) VALUES (NULL , 'Minnesota');
INSERT INTO `states` ( `id` , `state_name`) VALUES (NULL , 'Mississippi');
INSERT INTO `states` ( `id` , `state_name`) VALUES (NULL , 'Missouri');
INSERT INTO `states` ( `id` , `state_name`) VALUES (NULL , 'Montana');
INSERT INTO `states` ( `id` , `state_name`) VALUES (NULL , 'Nebraska');
INSERT INTO `states` ( `id` , `state_name`) VALUES (NULL , 'Nevada');
INSERT INTO `states` ( `id` , `state_name`) VALUES (NULL , 'New Hampshire');
INSERT INTO `states` ( `id` , `state_name`) VALUES (NULL , 'New Jersey');
INSERT INTO `states` ( `id` , `state_name`) VALUES (NULL , 'New Mexico');
INSERT INTO `states` ( `id` , `state_name`) VALUES (NULL , 'New York');
INSERT INTO `states` ( `id` , `state_name`) VALUES (NULL , 'North Carolina');
INSERT INTO `states` ( `id` , `state_name`) VALUES (NULL , 'North Dakota');
INSERT INTO `states` ( `id` , `state_name`) VALUES (NULL , 'Ohio');
INSERT INTO `states` ( `id` , `state_name`) VALUES (NULL , 'Oklahoma');
INSERT INTO `states` ( `id` , `state_name`) VALUES (NULL , 'Oregon');
INSERT INTO `states` ( `id` , `state_name`) VALUES (NULL , 'Pennsylvania');
INSERT INTO `states` ( `id` , `state_name`) VALUES (NULL , 'Rhode Island');
INSERT INTO `states` ( `id` , `state_name`) VALUES (NULL , 'South Carolina');
INSERT INTO `states` ( `id` , `state_name`) VALUES (NULL , 'South Dakota');
INSERT INTO `states` ( `id` , `state_name`) VALUES (NULL , 'Tennessee');
INSERT INTO `states` ( `id` , `state_name`) VALUES (NULL , 'Texas');
INSERT INTO `states` ( `id` , `state_name`) VALUES (NULL , 'Utah');
INSERT INTO `states` ( `id` , `state_name`) VALUES (NULL , 'Vermont');
INSERT INTO `states` ( `id` , `state_name`) VALUES (NULL , 'Virginia');
INSERT INTO `states` ( `id` , `state_name`) VALUES (NULL , 'Washington');
INSERT INTO `states` ( `id` , `state_name`) VALUES (NULL , 'West Virginia');
INSERT INTO `states` ( `id` , `state_name`) VALUES (NULL , 'Wisconsin');
INSERT INTO `states` ( `id` , `state_name`) VALUES (NULL , 'Wyoming');

Enjoy.

Incoming search terms:

• us state database mysql