按规则输出要求的sql,这个脚本怎么写？

bikong0411

awk 'NR==FNR{a[$2]=$1;next}{if($1 in a){printf "update mytable set myname='"'%s'"' where id=%d\n",a[$1],$2}}' id.txt my.log

代号：军刀

1. awk 'NR==FNR{a[$2]=$1}NR>FNR{print "update mytable set myname='\''"a[$1] "'\'' where id=" $2";" }' id.txt my.log

复制代码

seesea2517

纯属捣乱的。

1. [seesea@UC ~]$ sort -nk2.2 <(join -1 2 -2 1 -o1.1 2.2  <(sort -k2,2 id.txt) <(sort -k1,1 my.log)) | sed "s/ /' where id=/; s/$/;/; s/^/update mytable set myname='/"
   
2. update mytable set myname='单位七' where id=1;
   
3. update mytable set myname='单位一' where id=2;
   
4. update mytable set myname='单位三' where id=3;
   
5. update mytable set myname='单位七' where id=4;
   
6. update mytable set myname='单位六' where id=5;
   
7. update mytable set myname='单位七' where id=6;
   
8. update mytable set myname='单位二' where id=7;
   
9. update mytable set myname='单位九' where id=8;
   
10. update mytable set myname='单位二' where id=9;
    
11. update mytable set myname='单位一' where id=10;
    
12. update mytable set myname='单位六' where id=11;
    
13. update mytable set myname='特殊单位' where id=12;

复制代码