shell中的Mysql查询
时间：2022-03-10 17:20
1 #!/bin/bash
2 #查询
3 echo -e
4 for i in `cat id.txt`
5 do
6 A=`mysql -h10 -uw -p2012 -Ne "select
Id,Name,User_Logindate from info where Id=$i"`;
7 B=`mysql -h10 -uw -p2012
-Ne "select ifnull(sum( Amount),0) from Info where Date between
‘2014-05-21‘
and ‘2014-05-22‘ and Id=$i and Res=1"`
8 echo -e
"$A\t\t\t\t$B\t" >> tmp.xls;
9 done
shell中的Mysql查询,布布扣,bubuko.com
