#!/bin/bash
File=user`date +%Y%m%d`.xls
Path=/home/wym/ocssql/
AdminMail=XX@XXX
Msql=select.sql
Muser=admin
Mpass=XXX
mysql -u$Muser -p$Mpass < $Path$Msql > $Path$File
if [ $? = 0 ]
then
sleep 2
echo -e "hi everyone: \n please check user'drives" |mailx -s "userdrives" -a $Path$File $AdminMail
else
echo "Userdrive Add Flase" |mail -s "Attention" $AdminMail
fi