Problem with Bangladesh, country id 17

prograhammer / countries-regions-cities

MySQL ready-to-use tables with countries, regions/states and cities of the world.

358 stars 139 forks source link

Problem with Bangladesh, country id 17 #5

Open abedeenpro opened 6 years ago

abedeenpro commented 6 years ago

I found two problems. 1. SELECT * FROM regions WHERE regions.country_id=17 Bangladesh has 7 Division, though soon it may be 8. But U seen first row Name is empty.

2. SELECT *FROM cities INNER JOIN regions ON cities.region_id = regions.id WHERE cities.name = 'Dumuria' City Dumuria has repeated 3 times. Though there is only one Dumuria, it is in Khulna. And same problem, One region name missed. Tough Dumuria is not city but it can be considered.

I have not checked any other.

vodnicearv commented 6 years ago

and for Moldova, Republic of, same problems

Warafux commented 5 years ago

If you search for this pattern: \((\d+\, \'\')\, \'.+'\, .+\)\, You will find 502 occurrences matching the pattern: