statecountyfipdatacoordination

I am trying to insert a county search feature into my
program. I have a table of states, and now I want to
add a table of state counties
http://www.itl.nist.gov/fipspubs/co-codes/pa.txt

Ex. I have a table which identifies the state of
Pennsylvania as PA 42000

Now I want to make a table which identifies the
counties of PA ex.

42001 Adams
42003 Allegheny
42005 Armstrong
42007 Beaver
42009 Bedford

What is the procedure for uploading a lot of county data?
What is the procedure to link the state code with the
county codes within the mysql table?
What is the best php procedure to extract the data?

• Original URL: "https://sourceforge.net/p/phpmyadmin/support-requests/844/":https://sourceforge.net/p/phpmyadmin/support-requests/844/


• Original author: msszroberts

该提问来源于开源项目：phpmyadmin/phpmyadmin