##
mysql=/home/quentin/workspace/mysql/mysql_5.0.67/bin/mysql

interrupt(){
        exit
}
trap interrupt SIGINT SIGTERM
## loop endless updates:
##
## print a dot on every update to have some progress indicator.
##
for i in `seq 50000` ; do

  $mysql -uroot -p000 test -e "UPDATE t2 INNER JOIN t1 USING(knr) SET knr = NULL WHERE t1.em <> t2.em"
  sleep 1
  echo -n "$i "

done