What is the best way to store cities in this case?

Question

MySQL

What is the best way to store a list of cities in Russia and the world? We make a list of the cities of the online store available for delivery. We fill everything manually, because we gradually master the cities.
We are thinking of creating a cities table with the following structure:
id | full_name | short_name
for example:
1 | Kryzhopol, Vinnitsa region, Ukraine | Kryzhopol
full_name was made because sometimes there are cities with the same names. Or should we create multiple tables for cities, countries, regions, etc?

Answer 1

Make separate columns for the city, region, country, + you will probably need to specify the address of the street and house (if pickup for example)