how to organize country data?

Posted by fayer on Stack Overflow See other posts from Stack Overflow or by fayer
Published on 2010-03-19T03:39:12Z Indexed on 2010/03/19 3:41 UTC
Read the original article Hit count: 134

Filed under:

how do i organize country data (countries, states and cities etc) in mysql?

cause every country has 3 tables: countries, states and cities.

should i have each country in separate set of tables or should i have them all in these 3 tables? if i have all of them in same tables, im afraid that the amount of rows will be huge cause i tend to have a lot of countries!

what is best practice for this?

© Stack Overflow or respective owner

Related posts about mysql