Shell Programming and Scripting

 
Table1 Column1 123abc
Table1 Column2 xyz
Table2 Column1 543

UPDATE Table1 SET Column1='123abc';
UPDATE Table1 SET Column2='xyz';
UPDATE Table2 SET Column1='543';

#!/bin/sh
awk '
                {printf "UPDATE %s SET %s='%s';\n",$1,$2,$3;}
' F1.txt > s1.log

for rowdata in `cat F1.txt`
do
 ......statements
 ......statements
 echo  "UPDATE $rowdata (extract 1st Field) SET $rowdata (extract 2nd Field) = $rowdata (extract 3rd field);"
 
 ......statements
 ......statements
 
done >> s1.log

while read A B C
do
        echo "UPDATE $A SET $B='$C';
done < F1.txt

Table1,Column1,123abc
Table1,Column2,xyz
Table2,Column1,543

 
#!/bin/sh
OLDIFS="$IFS"
IFS=,
while read f1 f2
do
        echo "update $f1 set $f2=123;"
done < t2.log > s2.log
IFS="$OLDIFS"