You did not say what these data would be used for. Will there be heavy
reads? What is the time requirement for each query? Proper way to do
this would be by having three different normalized tables.
State:
state_id PK
state_name
County:
county_id (either abbreviate or create unique numeric id)
Hi,
I need to store all 50 states and there county + zip in mysql.
What is the best way to do it?
Should I just put them in to one table and use the states row for
primary Id? or
Put every state in separate table and use the zip row for primary Id?
Which would be faster to find a county?
The ma