Here is a SQL insert statement I used to quickly insert all USA states to a database.
Single SQL command
INSERT INTO State VALUES (null,'AL', 'ALABAMA',"US"), (null,'AK', 'ALASKA',"US"), (null,'AS', 'AMERICAN SAMOA',"US"), (null,'AZ', 'ARIZONA',"US"), (null,'AR', 'ARKANSAS',"US"), (null,'CA', 'CALIFORNIA',"US"), (null,'CO', 'COLORADO',"US"), (null,'CT', 'CONNECTICUT',"US"), (null,'DE', 'DELAWARE',"US"), (null,'DC', 'DISTRICT OF COLUMBIA',"US"), (null,'FM', 'FEDERATED STATES OF MICRONESIA',"US"), (null,'FL', 'FLORIDA',"US"), (null,'GA', 'GEORGIA',"US"), (null,'GU', 'GUAM',"US"), (null,'HI', 'HAWAII',"US"), (null,'ID', 'IDAHO',"US"), (null,'IL', 'ILLINOIS',"US"), (null,'IN', 'INDIANA',"US"), (null,'IA', 'IOWA',"US"), (null,'KS', 'KANSAS',"US"), (null,'KY', 'KENTUCKY',"US"), (null,'LA', 'LOUISIANA',"US"), (null,'ME', 'MAINE',"US"), (null,'MH', 'MARSHALL ISLANDS',"US"), (null,'MD', 'MARYLAND',"US"), (null,'MA', 'MASSACHUSETTS',"US"), (null,'MI', 'MICHIGAN',"US"), (null,'MN', 'MINNESOTA',"US"), (null,'MS', 'MISSISSIPPI',"US"), (null,'MO', 'MISSOURI',"US"), (null,'MT', 'MONTANA',"US"), (null,'NE', 'NEBRASKA',"US"), (null,'NV', 'NEVADA',"US"), (null,'NH', 'NEW HAMPSHIRE',"US"), (null,'NJ', 'NEW JERSEY',"US"), (null,'NM', 'NEW MEXICO',"US"), (null,'NY', 'NEW YORK',"US"), (null,'NC', 'NORTH CAROLINA',"US"), (null,'ND', 'NORTH DAKOTA',"US"), (null,'MP', 'NORTHERN MARIANA ISLANDS',"US"), (null,'OH', 'OHIO',"US"), (null,'OK', 'OKLAHOMA',"US"), (null,'OR', 'OREGON',"US"), (null,'PW', 'PALAU',"US"), (null,'PA', 'PENNSYLVANIA',"US"), (null,'PR', 'PUERTO RICO',"US"), (null,'RI', 'RHODE ISLAND',"US"), (null,'SC', 'SOUTH CAROLINA',"US"), (null,'SD', 'SOUTH DAKOTA',"US"), (null,'TN', 'TENNESSEE',"US"), (null,'TX', 'TEXAS',"US"), (null,'UT', 'UTAH',"US"), (null,'VT', 'VERMONT',"US"), (null,'VI', 'VIRGIN ISLANDS',"US"), (null,'VA', 'VIRGINIA',"US"), (null,'WA', 'WASHINGTON',"US"), (null,'WV', 'WEST VIRGINIA',"US"), (null,'WI', 'WISCONSIN',"US"), (null,'WY', 'WYOMING',"US");
Multiple Insert Commands
INSERT INTO state VALUES (NULL,'AL', 'ALABAMA','US');
INSERT INTO state VALUES (NULL,'AK', 'ALASKA','US');
INSERT INTO state VALUES (NULL,'AS', 'AMERICAN SAMOA','US');
INSERT INTO state VALUES (NULL,'AZ', 'ARIZONA','US');
INSERT INTO state VALUES (NULL,'AR', 'ARKANSAS','US');
INSERT INTO state VALUES (NULL,'CA', 'CALIFORNIA','US');
INSERT INTO state VALUES (NULL,'CO', 'COLORADO','US');
INSERT INTO state VALUES (NULL,'CT', 'CONNECTICUT','US');
INSERT INTO state VALUES (NULL,'DE', 'DELAWARE','US');
INSERT INTO state VALUES (NULL,'DC', 'DISTRICT OF COLUMBIA','US');
INSERT INTO state VALUES (NULL,'FM', 'FEDERATED STATES OF MICRONESIA','US');
INSERT INTO state VALUES (NULL,'FL', 'FLORIDA','US');
INSERT INTO state VALUES (NULL,'GA', 'GEORGIA','US');
INSERT INTO state VALUES (NULL,'GU', 'GUAM','US');
INSERT INTO state VALUES (NULL,'HI', 'HAWAII','US');
INSERT INTO state VALUES (NULL,'ID', 'IDAHO','US');
INSERT INTO state VALUES (NULL,'IL', 'ILLINOIS','US');
INSERT INTO state VALUES (NULL,'IN', 'INDIANA','US');
INSERT INTO state VALUES (NULL,'IA', 'IOWA','US');
INSERT INTO state VALUES (NULL,'KS', 'KANSAS','US');
INSERT INTO state VALUES (NULL,'KY', 'KENTUCKY','US');
INSERT INTO state VALUES (NULL,'LA', 'LOUISIANA','US');
INSERT INTO state VALUES (NULL,'ME', 'MAINE','US');
INSERT INTO state VALUES (NULL,'MH', 'MARSHALL ISLANDS','US');
INSERT INTO state VALUES (NULL,'MD', 'MARYLAND','US');
INSERT INTO state VALUES (NULL,'MA', 'MASSACHUSETTS','US');
INSERT INTO state VALUES (NULL,'MI', 'MICHIGAN','US');
INSERT INTO state VALUES (NULL,'MN', 'MINNESOTA','US');
INSERT INTO state VALUES (NULL,'MS', 'MISSISSIPPI','US');
INSERT INTO state VALUES (NULL,'MO', 'MISSOURI','US');
INSERT INTO state VALUES (NULL,'MT', 'MONTANA','US');
INSERT INTO state VALUES (NULL,'NE', 'NEBRASKA','US');
INSERT INTO state VALUES (NULL,'NV', 'NEVADA','US');
INSERT INTO state VALUES (NULL,'NH', 'NEW HAMPSHIRE','US');
INSERT INTO state VALUES (NULL,'NJ', 'NEW JERSEY','US');
INSERT INTO state VALUES (NULL,'NM', 'NEW MEXICO','US');
INSERT INTO state VALUES (NULL,'NY', 'NEW YORK','US');
INSERT INTO state VALUES (NULL,'NC', 'NORTH CAROLINA','US');
INSERT INTO state VALUES (NULL,'ND', 'NORTH DAKOTA','US');
INSERT INTO state VALUES (NULL,'MP', 'NORTHERN MARIANA ISLANDS','US');
INSERT INTO state VALUES (NULL,'OH', 'OHIO','US');
INSERT INTO state VALUES (NULL,'OK', 'OKLAHOMA','US');
INSERT INTO state VALUES (NULL,'OR', 'OREGON','US');
INSERT INTO state VALUES (NULL,'PW', 'PALAU','US');
INSERT INTO state VALUES (NULL,'PA', 'PENNSYLVANIA','US');
INSERT INTO state VALUES (NULL,'PR', 'PUERTO RICO','US');
INSERT INTO state VALUES (NULL,'RI', 'RHODE ISLAND','US');
INSERT INTO state VALUES (NULL,'SC', 'SOUTH CAROLINA','US');
INSERT INTO state VALUES (NULL,'SD', 'SOUTH DAKOTA','US');
INSERT INTO state VALUES (NULL,'TN', 'TENNESSEE','US');
INSERT INTO state VALUES (NULL,'TX', 'TEXAS','US');
INSERT INTO state VALUES (NULL,'UT', 'UTAH','US');
INSERT INTO state VALUES (NULL,'VT', 'VERMONT','US');
INSERT INTO state VALUES (NULL,'VI', 'VIRGIN ISLANDS','US');
INSERT INTO state VALUES (NULL,'VA', 'VIRGINIA','US');
INSERT INTO state VALUES (NULL,'WA', 'WASHINGTON','US');
INSERT INTO state VALUES (NULL,'WV', 'WEST VIRGINIA','US');
INSERT INTO state VALUES (NULL,'WI', 'WISCONSIN','US');
INSERT INTO state VALUES (NULL,'WY', 'WYOMING','US');