----- Original Message -----
> From: "joe j" <[email protected]>
>
> 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?
You can't create multiple tables with one statement; but you *can* put multiple
statements on a single line. However, this does nothing for performance - nor
readabiltiy, for that matter :-)
You could (on *nix) write a simple commandline loop for it, I suppose.
Something along the lines of
for x in UK US BE FR; do mysql -e "create table ${x}_table_new as select
blahblahblbah"; done
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
