合同比对

最新推荐文章于 2024-08-21 11:07:53 发布

weixin_30858241

最新推荐文章于 2024-08-21 11:07:53 发布

阅读量959

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/zhaoyangjian724/p/6200370.html

版权

for((i=15;i<=174;i++));do
if [ -d "$i" ]
then
cd $i
echo 当前产品sn==$i
ls -ltr *pdf | grep -v tmp  | wc -l
cd ..
fi
done

mysql -uroot -p'xxxxxx' -e "select * from (select productSn  from zjzc.ClientInvestOrder  order by sn) a group by productSn" | while read A
do
echo 当前产品sn==$A
mysql -uroot -p'xxxxxxxx' -e "select count(a.clientSn) from zjzc.ClientPersonalInfo a ,zjzc.ClientInvestOrder b where a.clientSn=b.clientSn and b.productSn='$A';"
done

转载于:https://www.cnblogs.com/zhaoyangjian724/p/6200370.html