I have a friend with pretty big db with users from all over the world.
The table have a lot of info about the users, like name, address, e-mail, country, and so on.
Now he wants to add one field to the db, listing what continent they live in.
So, all the people in France will have Europe added.
I’m not sure how I can do this the easiest way. Should I run a query for every country and change.
Or is it easier to make some kind of temporary web page where they are listed and I can click on the correct continent.
That would be pretty good, not sure how though, but if I had a list of the users sorted by country.
Like a table
NAME | COUNTRY | CONTINENT MENU LIST
Peter USA North America, South America, Europe, Asia,…
Michel France North America, South America, Europe, Asia,…
Then, when picking North America on the first one, all the others that have USA as country will be updated with the same continent.
Is that something that can be done or is there an easier way of doing it?