Re: Tables cities and table user

From: ^Bart <gabriele1NOSPAM_at_hotmail.com>
Date: Sat, 9 Feb 2019 10:50:30 +0100
Message-ID: <q3m7p6$q11$1_at_gioia.aioe.org>


> SELECT id_city,name,'IT' from cities_it
> union all
> SELECT id_city,name,'UK' from cities_uk

[Quoted] [Quoted] I didn't understand what happen in the cities table when you use the [Quoted] union all command...

> or, even better (before someone else askes this question):
> Why do you have mulitple tables with city names?

[Quoted] [Quoted] Because I think to store all cities from more or less ten countries or [Quoted] the entire world it's too heavy to to it just in one table!

^Bart Received on Sat Feb 09 2019 - 10:50:30 CET

Original text of this message