- Original Message -
> From: "joe j"
>
> Good suggestion. But I am a perl/unix illiterate. However I may learn
> in them future-you never know!
You're never too old to learn :-)
http://tldp.org/LDP/abs/html/
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwe
>Jan Steinman wrote
>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!
Good suggestion. But I am a perl/unix illiterate. However I may learn
in them future
> From: joe j
>
> 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 per
Thanks, Johan.
I run the script in Unix indeed-don't know why I said Dos:)
The problem is caused (at least that is the sense I get, so far) when
I use some conditional statements inside "case when" as:
(case when (country='${x}' AND var2<>"") then 1 else 0 end)
The problem lies with the "<>" pa
- Original Message -
> From: "joe j"
>
>
> /*STEP 2. from the dos prompt?*/
>
> for x in UK ZA IN CN;
> do mysql -ujoe -p -e "INSERT INTO `table_new`
> SELECT var1, var2`, (case when (country='${x}') then 1 else 0 end) AS
> citizen
> ,'${x}' AS ctry
> FROM `'${x}'_table`
> LEFT JOIN
>
- Original Message -
> From: "Rick James"
>
> That sounds like the wrong way to design the schema. Why not have
> `country` as a column in a single table?
Given that he got all the data for the new tables from existing ones, I was
assuming he needed separate tables for some specific pu
Thanks to Rick I would go for a single table. I tried the following,
but hasn't been successful yet. First I created one 'master' table for
one country, with a country column (ctry) as Rick suggested, then I
tried to use the loop suggested by Johan to insert the records for
each of the remaining co
That sounds like the wrong way to design the schema. Why not have
`country` as a column in a single table?
On 4/3/12 6:22 PM, Hal?sz S?ndor wrote:
2012/04/03 22:27 +0200, joe j
So what I am trying to get is a script that runs through a list of
country names (US, UK, NL, etc) and create ta
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 wrote:
> - Original Message -
>> From: "joe j"
>>
>> So what I am trying to get is a script that runs
- Original Message -
> From: "joe j"
>
> 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* p
2012/04/03 22:27 +0200, joe j
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?
There are PROCEDUREs, and there is PREPARE. Look them up.
--
MySQL Gener
11 matches
Mail list logo
