#!/bin/sh
mysqlconn="mysql -uroot"
db="dbname"
table1="tablename"
while($mysqlconn -N -e "select item_id from $db.$table1 where matching_status = 0 limit 1;")
do
#echo 1
$mysqlconn -e "update $db.$table1 set matching_status = 1, matching_fail_reason = null, pim_flag = 0 where matching_status = 0 limit 10000"
done
mysqlconn="mysql -uroot"
db="dbname"
table1="tablename"
while($mysqlconn -N -e "select item_id from $db.$table1 where matching_status = 0 limit 1;")
do
#echo 1
$mysqlconn -e "update $db.$table1 set matching_status = 1, matching_fail_reason = null, pim_flag = 0 where matching_status = 0 limit 10000"
done