FILE=a.txt
DATABASE=test
PD=123456
echo "" > $FILE
RKYHL="select count(*) from t_profile"
JMCC="select count(*) from t_profile where status=2"
60SWJM="select count(*) from t_profile where speech_len>60 and status<2 "
echo "数 量: `mysql -u root -P 3307 -p$PD -D $DATABASE -e "$RKYHL"` " >> $FILE
echo "建模成功: `mysql -u root -P 3307 -p$PD -D $DATABASE -e "$JMCC"` " >> $FILE
echo "60s未建模: `mysql -u root -P 3307 -p$PD -D $DATABASE -e "$JMCC"` " >> $FILE
不登录mysql,查看sql执行结果
于 2023-04-06 16:30:07 首次发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)