Re: Making Tables from Values in a Field

[Thomas Stieve]

Thank you for the replies. This is an ongoing project. I have downloaded the data from Wikipedia by language Wiki. My final product is one database with rows that contain article titles in English and the number of countries of origins of the IP edits. It's not a database that will be maintained. It's a one time project. My thought is to do something like:

CREATE OR REPLACE TABLE belgium.abkhazian
SELECT *
FROM ab_edit_en
where ab_edit_en.country = "Belgium";

Where belgium.abkhazian is the Abhazian edits from Belgium that will be located in the Belgium database. These are selected from the Abkhazian language database that contain IP origins in Belgium. So, I'm going through the field "country," finding those edits in Belgium, and putting them in the newly created database Belgium.

I'm still fairly new to MySQL, so I'm learning as I go along in this project. I would like to automate dropping tables that are empty, but I see that's a stored procedure (IF statement).

Any feedback from someone who has more experience is appreciated.

Thanks!