mysql 脚本

cat abc.sh
#!/bin/sh
exec 3<kxt.c
while read -u3 t1 t2
do

        str1='update sm_user set code="tmp"  where code="'

        str4='";'

        str2='update sm_user set code="'

        str3='" where code="'


        #str5='update sm_user set code="'

        str6='" where code="tmp";'





        sqlstr=$str1$t2$str4    #kxt2-->tmp
        echo $sqlstr>>ds.sql

        sqlstr=$str2$t2$str3$t1$str4    #tmp-->kxt1

        echo $sqlstr>>ds.sql

        sqlstr=$str2$t1$str6    #kxt1-->kxt2

        echo $sqlstr>>ds.sql
done