?
Solved

need complete cities and states mysql table

Posted on 2014-09-10
7
Medium Priority
?
210 Views
Last Modified: 2014-09-20
Anyone know of a cities, states, countries mysql table which is free and very complete?
0
Comment
Question by:projects
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 2

Expert Comment

by:Akilandeshwari N
ID: 40315213
You can download the comma separated data freely using the below link.

http://www.populardata.com/downloads/zip_codes.zip

Create the table and just load this file into your database.
0
 

Author Comment

by:projects
ID: 40315235
Cities, States, Countries... as in world wide. This is US only.
0
 
LVL 2

Expert Comment

by:Akilandeshwari N
ID: 40315338
0
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 

Author Comment

by:projects
ID: 40316062
I saw this a while back but the license talked about not being able to use it on a commercial site I believe. It's possible that the client could use it in some commercial manner however, it's not in any geo way, it's only to make sure that people pick consistent city/state/country info.
0
 
LVL 2

Accepted Solution

by:
Akilandeshwari N earned 2000 total points
ID: 40316261
You will have to go for a premium database then
0
 

Author Comment

by:projects
ID: 40318286
I have to believe there is a good complete one out there. It's the geo data that costs money and I don't need any of those things. I just want users to pick rather than free hand enter otherwise we'll end up with a number of variations for one city or state, etc
0
 

Author Comment

by:projects
ID: 40334460
I've requested that this question be deleted for the following reason:

I have opted to build my own solution so the question is moot.
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question