> From: joe j <joe.st...@gmail.com>
>
> 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!
Is there any reason (besides human keystrokes) that you want a short script?
If not, how 'bout the best of both worlds: create a UNIX (or perl) script that
loops through the country names and creates an SQL script? That would be fast
entering AND fast performing!
> 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
----------------
Expose yourself to your deepest fear; after that, fear has no power, and the
fear of freedom shrinks and vanishes. You are free. -- Jim Morrison
:::: Jan Steinman, EcoReality Co-op ::::
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
