#844 state county fip data coordination

[msszroberts]

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?

[Michal Čihař]

Logged In: YES
user_id=192186

Best way to upload huge data is using command line mysql,
you can link InnoDB tables by native relations. Extract data
as any other.

I don't see here much phpMyAdmin related.

[msszroberts]

Logged In: YES
user_id=1361557

Hi nijel,

Hi Nigel,
You may be right that about my questions not being related
to phpMyAdmin. If so, then I appologize, but thanks for
your feedback anyway. I posted to the phpMyAdmin forum
because that is what I currently use to make small editing
changes to the tables in my MySql database. I was told that
it is much easier to manage the databases with phpMyAdmin
than through MySQL. However, you are suggesting that I was
given some bad information. Again, my appologies.

[Michal Čihař]

Logged In: YES
user_id=192186

For small changes it is best :-). Hoverver for uploading big
database, command line client is better.

[SourceForge Robot]

Logged In: YES
user_id=1312539

This Tracker item was closed automatically by the system. It was
previously set to a Pending status, and the original submitter
did not respond within 14 days (the time period specified by
the administrator of this Tracker).