select xxx into outfile from shell

#!/bin/bash

#Script. Name:test_seal_activity.sh

#Descript. export data from seal_activity between now()-1 10:00:00 and now() 10:00:00

#define export DataBAse

DbName=testDB

#define userName and Passwd

#Dbusr=us_test

#Dbpasswd=us_test

#Dbport=port

#Dbhost=xx.xx.xx.xx

#define time export data

expdate=`date +%y%m%d`

echo ${expdate}

#define export table format

exptab=table_Name.OpenId_${expdate}.txt

echo ${exptab}

#导出数据非Linux本地

mysql -h ${Dbhost} -P ${Dbport} -u ${Dbusr} -p${Dbpasswd} -e "SELECT OpenId  FROM ${DbName}.table_Name WHERE Seal_Count > 0 AND Create_Time BETWEEN CONCAT(DATE_ADD(CURDATE(),INTERVAL -1 DAY),' 10:00:00') AND CONCAT(CURDATE(),' 10:00:00')" > /data/ExpActivity/${exptab};

#导出数据在Linux Server

mysql -h ${Dbhost} -P ${Dbport} -u ${Dbusr} -p${Dbpasswd} -e "SELECT OpenId into outfile '/data/ExpActivity/${exptab}'  FROM ${DbName}.table_Name WHERE Seal_Count > 0 AND Create_Time BETWEEN CONCAT(DATE_ADD(CURDATE(),INTERVAL -1 DAY),' 10:00:00') AND CONCAT(CURDATE(),' 10:00:00');"

sleep 1

cd /data/ExpActivity

zip -r Open_Id_${expdate}.zip ${exptab}

sleep 1

rm  /data/ExpActivity/${exptab}

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26855487/viewspace-740554/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26855487/viewspace-740554/