From: Baumann, Michael (m.baumannsiemens.com)
Date: Wed Jun 11 2008 - 02:17:20 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hi there,
I got a quite weird problem. Trying to update a table via a batch shell
script that looks like this
 
<snip>
while read AAA BBB
do
    mysql -u $DBUSER --password=$DBPASS --batch "--execute=update
XY_Table \
        set Column1 ='"$BBB"' where Column2 = '"$AAA"' LIMIT 1;" DBTABLE
>>$LOGFILE
    echo "AAA: "$AAA" BBB:"$BBB" End"
done <$INFILE
</snip>
 
With lines in $INFILE looking like this:
<snap>
1234 A - > 12 PCs
2345 B - > 13 < 100 PCs
....
</snap>
 
The weird thing is that the echo works properly and gives me results
like
AAA: 1234 BBB: A - > 12 PCs End
AAA: 2345 BBB: B - > 13 < 100 PCs End
...
 
But the mysql -u does not work and returns the sytax page to $LOGFILE
 
When I have a similar command using a fixed string (such as abcdef)
instead of $BBB (also omitting the "s around $BBB in the mysql command)
it works fine.
 
any ideas?
 

kind regards
Michael Baumann

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]