Dear all,
I need to create over 100 tables each representing a country. Instead
of repeating the commands could I create all tables in one single
query?

The following are two examples of the tables I'd like to create:
1. for USA
CREATE TABLE `US_table_new`
SELECT var1, var2`
, (case when (country='US') then 1 else 0 end) AS US_citizen
FROM `USA_table_old`
LEFT JOIN
WORLD
USING(YEAR);

2. for UK
CREATE TABLE `UK_table_new`
SELECT var1, var2`
, (case when (country='UK') then 1 else 0 end) AS UK_citizen
FROM `UK_table_old`
LEFT JOIN
WORLD
USING(YEAR);

So what I am trying to get is a script that runs through a list of
country names (US, UK, NL, etc) and create tables for each one of them
as above. Is this feasible in MySql?

Thanks,
Joe.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql