统计特定的字符串在数据库表中出现次数

dbname=dbname


sgrep= searchstring


mysqlshow -ugaofei -p`cat pass_yfb` -h 172.16.3.29 ${dbname} |awk 'NR>4 {print $2}' > ${dbname}_tables_all.cfg


for t_name in `cat ${dbname}_tables_all.cfg ` ; do
  mysqldump -ugaofei -p`cat pass_yfb` -h 172.16.3.29 --no-create-info ${dbname} $t_name > tmp_${dbname}_dump.sql
  echo $t_name “:”`grep -i ${sgrep} tmp_${dbname}_dump.sql | wc` > ${dbname}_tables_result.out
done;