Re: batch in a read loop

2008-06-11 Thread Sebastian Mendel
Baumann, Michael schrieb: Hi there, I got a quite weird problem. Trying to update a table via a batch shell script that looks like this while read AAA BBB do mysql -u $DBUSER --password=$DBPASS --batch "--execute=update ^ i guess your qu

batch in a read loop

2008-06-11 Thread Baumann, Michael
Hi there, I got a quite weird problem. Trying to update a table via a batch shell script that looks like this 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