Re: Tables cities and table user
From: The Natural Philosopher <tnp_at_invalid.invalid>
Date: Sat, 9 Feb 2019 10:51:00 +0000
Message-ID: <q3mbak$kr2$1_at_dont-email.me>
>
> 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!
>
Date: Sat, 9 Feb 2019 10:51:00 +0000
Message-ID: <q3mbak$kr2$1_at_dont-email.me>
[Quoted] On 09/02/2019 09: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!
>
[Quoted] I dont think so.
You need a table of countries and a table of cities.
In the city record you have a field that points to the country unique ID
If you are worried about lookup speed, index it
> ^Bart
>
-- To ban Christmas, simply give turkeys the vote.Received on Sat Feb 09 2019 - 11:51:00 CET