Re: Tables cities and table user
From: Luuk <luuk_at_invalid.lan>
Date: Sat, 9 Feb 2019 11:02:06 +0100
Message-ID: <5c5ea4ea$0$22360$e4fe514c_at_news.xs4all.nl>
>
> I didn't understand what happen in the cities table when you use the
> union all command...
>
>
> Because I think to store all cities from more or less ten countries or
> the entire world it's too heavy to to it just in one table!
>
> ^Bart
>
Date: Sat, 9 Feb 2019 11:02:06 +0100
Message-ID: <5c5ea4ea$0$22360$e4fe514c_at_news.xs4all.nl>
On 9-2-2019 10:50, ^Bart wrote:
>> SELECT id_city,name,'IT' from cities_it >> union all >> SELECT id_city,name,'UK' from cities_uk
>
> I didn't understand what happen in the cities table when you use the
> union all command...
>
>> or, even better (before someone else askes this question): >> Why do you have mulitple tables with city names?
>
> Because I think to store all cities from more or less ten countries or
> the entire world it's too heavy to to it just in one table!
>
> ^Bart
>
https://www.reference.com/geography/many-cities-world-c25cce21cb142891 It is important to define the word "city" before beginning to answer how many there are. The United Nations has contradictory definitions in its reports. A report compiled from World Atlas calculated that there were 4,416 cities in the world with a population of over 150,000. Received on Sat Feb 09 2019 - 11:02:06 CET