----- Original Message -----
> From: "joe j" <joe.st...@gmail.com>
>
>
> /*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
> WORLD
> USING(YEAR)";
>
> For some reasons step2 is not working.
Could you, perphaps, specify the reasons? Errormessages et al :-)
> I assume step 2 must be run from DOS prompt (my mysql runs on a
> server, and I am using PuTTY). Any thoughts?
DOS? Ick. Heathen.
Anyway, that loop won't work on a DOS prompt - it's Unix stuff. I suppose you
can achieve similar things with Powershell, but that's going to be distinctly
not *my* problem :-)
If your server is running on a Unix, you'll of course need to run it there. The
backticks will be an issue inside double quotes, though, and I don't see any
need for quoting. There's something weird about your query, though...
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 WORLD USING(YEAR)
There seem to be an extraneous backtick right after var2? Also, no need to
quote the ${x} bit - the shell will substitute that before MySQL sees it.
Definitely remove all the backticks from the expression - those mean "execute
this here".
--
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
