Thanks. I was looking for a loop--not to gain speed but to reduce the
length of my script file:) I'll try and hopefully it will work!
J
On Wed, Apr 4, 2012 at 12:16 PM, Johan De Meersman <vegiv...@tuxera.be> wrote:
> ----- Original Message -----
>> From: "joe j" <joe.st...@gmail.com>
>>
>> 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
