Cities make reference to non state...

hiiamrohit / Countries-States-Cities-database

Database & Dropdown Demo

http://www.iamrohit.in/countries-states-and-cities-database-of-world-in-mysql/

919 stars 1.07k forks source link

Cities make reference to non state... #2

Open rcolmenarez opened 8 years ago

rcolmenarez commented 8 years ago

The cities Awbari and Ghat (ids 26069 and 26070), belongs to a state with the id 2182, but in the states table, it doesn't appear any record with such id...

Hence when you upload this to a relational model it gaves you an error...

rb4bhushan commented 8 years ago

These two cities have reference in State table and belongs to 'Banghazi' (Id 2182). @rcolmenarez , I think, you have mistaken something in sql. city

javydreamercsw commented 8 years ago

See Issue https://github.com/hiiamrohit/Countries-States-Cities-database/issues/5. It has a related pull request.

javydreamercsw commented 8 years ago

This can be closed.