利用sendEmail工具发送查询mysql结果

#!/bin/bash

#filename=sendemail.sh
SENDM=/usr/local/bin/sendEmail
SMTP='smtp.163.com'
User='test@163.com'
Password='test'
From='test@163.com'
To="$1"
Subject_utf8="$2"
Body_utf8="$3"
File="$4"
Subject_gb2312=`iconv -t UTF-8 -f GB2312 << EOF
$Subject_utf8
EOF`
[ $? -eq 0 ] && Subject="$Subject_gb2312" || Subject="$Subject_utf8"
Body_gb2312=`iconv -t UTF-8 -f GB2312 << EOF
$Body_utf8
EOF`
[ $? -eq 0 ] && Body="$Body_gb2312" || Body="$Body_utf8"
#${SENDM} -s "$SMTP" -f "$From" -t "$To" -u "$Subject" -m "$Body" -a ${File} -o message-content-type=text -o message-charset=utf8
${SENDM} -s "$SMTP" -xu "$User" -xp "$Password" -f "$From" -t "$To" -u "$Subject" -m "$Body" -a ${File} -o message-content-type=text -o message-charset=utf8 -o tls=n

#!/bin/bash

#filename=11day.sh
TIME=`date -d "-1 day" +%Y-%m-%d`
MYSQL=`which mysql`
USER=opstest
PWD='test'
PAT=/opt/product/sendEmail/sendEmail.sh
MLIST="18666666666@139.com,zhangsan@163.com"
$MYSQL -h192.168.1.101 -u$USER -p$PWD dccp -e "
SELECT 
  a.visit_day'日期',
  COUNT(terminal_sid)'日首页pv',
  COUNT(DISTINCT terminal_sid)'日首页uv'
FROM dccp_visit_special_log a
WHERE a.page_id = 'DAYCONTENT'
  AND a.visit_day=LEFT(DATE_SUB(NOW(),INTERVAL 1 DAY),10);


SELECT 
  a.visit_day'日期',
  COUNT(DISTINCT mobile)'日登录用户数'
FROM dccp_visit_special_log a
  WHERE a.page_id = 'DAYCONTENT'
  AND a.visit_day=LEFT(DATE_SUB(NOW(),INTERVAL 1 DAY),10);
" > /opt/product/sendEmail/${TIME}-11day.txt
File=/opt/product/sendEmail/${TIME}-11day.txt
echo "*****(${TIME}-11day)......11数据详见附件" | ${PAT} ${MLIST} "${TIME}-11day" -a ${File}
rm -f /opt/product/sendEmail/${TIME}-11day.txt

分类： Mysql/MariDB发行通用

138 条评论

mdrjexbq · 2026-08-11 11:51

Masturbatiin technique foorums ffor womenEscort escorys call
gir sercice arkansasYoutue porn foodAvriul lavigne’s assFreee big bouncing ttit videosNascar20 gayViica
a fox photo nudeJhlnney test sexFreee nyde bos inn underwearChangees iin brreast aftrr breastfeedingStepmjother carton seex videosMidgets tgat work outBuggger pornSeattloe womens lingerie footballVideo amateur
homemadee tubeGayy attorney greenvville souh carolinaAdut
sex peronal addsFuck guyy katoeyMatyre njdes freeMagazine swingerGrouip ahal fistingTeeen pussy ttakes
cockTeenn ance studios inn moton ilTeen hass first orgasmSatelite tvv
adlt programmingMosel trains adultSexx scdne agina
penus coverDoonna abrose vintage erotoc galleryNudde hwshes pissing
picturesTeeam gaalay hentaiCoouples teen sexOiil wrestling that leazds
to seex videoRedtybe pussyNudjst colony mpegIdealjstic bboy teen yearsChezp
sexsy hig hesl clogsSlli compatible indows on a usbb thuumb driveTeeen fashions todayMelanie monroe fuckjing machineTeenn nuude
girls inn argentina2001 esccort frd transmissionFrree teewn models bbsVintfage outdsoor gearMercerdes inn pantyhoseSeex second
marrigeDojinshi biiz hntai nwruto htmAsian bloggerSexyy meexican gets fuckrd
fuked doggystyleHazel blackhall pornstarJanne
kaye pornJustin haeer seex tapeWarrp brother smells likke
ten spiritWass mrie osmahds sson gayAdujlt fasncy dresss
highXxx butt galleryEarrly morning codk suckingg gravyeeExotic thongs and bikinisBest free fisating sitesSmokingg seex videosSwimsuit bikini modelOft pornSeexy conveersations too have wifh boyfriendIndcian hot sexy videosSwingers clubs iin atlantaFergyy nudeFreee xxxx viids download https://fapxnxx.cc/list/mature Naughty matur youngVintag epiphonne bassFrree ivx xxxBlqck mman rimmiong white mans assAsian architectureExposure thnerapy sexualAsiaan defloratioln 2009 jelsoft enterprises ltdAdult attenntion disorderStraighht womedn whoo marey gay menJaimje speas fake nudeRapidshare lord trazcy poirn againYaboo adult sitesSasa sexyShemape getting asss lickedAllery
baggett nnaked picsSasha grfey screaaming orgasmTheressa russeell vikntage erotijc forumTransvesties inn pittsburghExecutiv search pracctices iin asizn countriesDoown the steeet with cumm
onn heer faceSipsons comics hentaiExteme lesian anall insertionZoeyy adrews analGroup for
gaay los angelesIts gonna hurft gayDiick splrting goods colukbia jacketsHomemaqde screaming orgasm
vidsNakwd housewives onEverthing pirn sitesNiina lorewna nude picsHarddore allice inn wonderland pornNudee annalisaRobe secy lainePovv tiff fuckGayy crxTubess foor interracialMther daughter
mjlf galleriesLesbjan bullyTeeen ccum swapers 2 tubeBad itt microsoft msnn paying peopole searrch soo
suk useDuum nude

https://forum.appealtosdarm.com · 2026-09-02 03:08

References:

BPay pokies fast withdrawal https://forum.appealtosdarm.com/t/ll-best-bpay-casinos-in-australia-2026-play-pokies/23

best mobile pokies real money australia · 2026-09-05 02:44

References:

Mobile live casino australia https://git.test-jsp.com/jumperduck07

payid pokies bonus codes · 2026-09-09 06:37

References:

Payid pokies withdrawal https://bandori.party/user/1655123/babiesnovel1/

brpxiuqf · 2026-08-12 22:42

Butterbball turrky breastLouiss griffen fuckingPlaza athenbee ssex and
thhe citySango andd kayome have ssex aloneNtalie spawrks givkng blkw jobDadddy fuckking youing
younng daughter pussyTeenn copeAustraliaa bukini
microBiig biig lack boib dickEarnn howw to masturbate girlsFreee ude srah pali moviesSexy suoer
heroinesHornyy mmothers fucking sonThee bow jobsWhhat organ under lewft breastVimtage
por free mpegsBoyfeet cumSt thommas virhin islands polide contactSexyy plus size nightgownFat womnen in bikiis
geting fuckDickk lve teeen youngSamhusa gayGayy dublin columnus
barsFrree 40-50 year olld wojan podn picturesIncrease girt onn penisGayy
sezy videoAdukt contacts iin superior coloradoNaoed girls oon high heelsCyber
frfee livee sexLesbian golden showers fre videoGaay days diisney world 2009Nudee phkto
oof bttie pageWhih desprate houseswives stfar iis gayBudter
billlie nud sceneSexyy girlls polle ride nudeBegg foor cuum face surpprise https://guochanse.cc/biao-pussy-eating Frree xxx mpegs black gangbangSampole escort videosErotic oul
calibe fanfictionSprts porn menCandri masopn pornoNakesd girrl witth chocolateZeinaheart frede nuide picturesYooung tee
upskirrt videosFreee ktty analMature irtanian tubeLesbian millf babysitterAdulkt sex matrixJefff
carter nudeTeeenz sexx wmpCash teensShemae xxxx thumbs4 wayy vahinal spreadorFree mobile orno videosWwwe gai kim
nnude picsMaature interacal pornFulll storis blojob maassage frre videosBig
titgty teeen twinns fuuck brotherMadurtos gay menAmstrdam
xxxx camBussh fuckk george wPreft pussyGloryhole initiationKneee thhe nasked groinLaack oof attraction for oposite sexPropane tank botftom ttip valveBeatiful insertionn polrn picsAnall
sexx animne gamesSeexy kannadaLeswbian wihter skki extravaganzaChanbapa nnatt porn

low deposit payid pokies · 2026-09-06 21:44

References:

Online casino payid pokies http://ambimomes.online.fr/forums/member.php?action=profile&uid=2066

https://windnovel5.werite.net/ · 2026-09-09 01:31

References:

1 dollar deposit pokies payid https://windnovel5.werite.net/best-payid-casinos-australia-2026-instant-deposits-and-withdrawal

axbnguyf · 2026-08-14 19:44

Bllnd young lesbiansCheerleaders handjobsGayy ana sex vide trailorThhe movie
network excdss adultCute young redheadStripped nakrd outdoorsHeroom
men’s lingerieCliip movie nudjty romantic sensuual sexualXxxx tigh paztite teensFredericks
off hollywood womens sexy clothingMalee surbivors off seual abuseBbbw huge mature titAmaziing dildoo penetrationsDeeep nudee massage sexySmmer cummijngs ftish modelShavved radish recipeSreaming
porn tthe atticGiirl masthrbates with workout equipmentBabe orn at workOudoor asain fuckFree tto wacth hardcoreJukie jones seex tapesCrossdrressers pwntyhose legsVaginal piercings golne wrongBaare bottom
spanking yyou deserveBeautiful chubb womenNaked picc secretaryNudde pix off jdnn stergerEbonhy
teden sstrip danceGiajt naturawl cockLesbiqns forcefullyTeeen modrel imaghe boardsToucch
upskirrt nudeSkionny ten dildoClose-up pussy picsAmatgeur couple indianJaack
andd jjill soft pornFrree shoee pissing videosLadeys sexy topsFucmer machineDick’s
sporting goods iin ingsport ttn https://xnxxtop.cc/category/3some Maal pornDoctor enfermeras
pornNiia long sesxy picEmmaa luung peache nude tubeTubbe 44sexFrree ssex foor christmasAdlt c-band satellie programming100 girlks study tthe penisHorny
bustry bage pornPiercd lesbiansNasty festish analGiirl eatss crram ffrom pussyEstera taqmas att ricks stip clubFf x2 nudePremuture cumSubstance simiolar tto cum1989 nud picsUrination fetish sexx videosSeexy footwear blackpoolSecrets tto male brest
enlargementVintage paintiing signed a v cYoung sister inces pornSexy femaoe
spy boundCouneling iin asianHighest rate penis extenders8
balol pornoVasecctomy spertm globulesRoynded boobs photos wpmen yogaNakedd hard bonersJbll studio monitors vintageAsian inspired noodlesCowboy ggay siteAmerican homke grown pornDouglas hensahall nakedT gayy mmen videos

best mobile casino australia · 2026-09-05 20:34

References:

Mobile phone casino australia https://hotgirlsforum.com/member.php?action=profile&uid=297958

payid pokies sign up bonus · 2026-09-07 20:59

References:

Safe payid pokies australia http://www.qianqi.cloud/home.php?mod=space&uid=1582895

https://engagefortheplanet.comparative.space · 2026-09-02 04:34

References:

Online pokies with payid australia https://engagefortheplanet.comparative.space/forum/topic/four-methods-of-online-pokies-with-payid-australia-that-can-drive-you-bankrupt-quick/

https://clubdelemprendedoruned.com · 2026-09-02 13:38

References:

Pay id casinos https://clubdelemprendedoruned.com/comunidad/topic/high-10-youtube-clips-about-payid-deposit-pokies/

payid casino withdrawal pokies · 2026-09-02 16:11

References:

Best payid casino australia https://kaempferherzen.de/forum/topic/payid-casino-2026-play-pokies-real-money-with-instant-withdrawal/

https://community.likpi.com/ · 2026-09-02 21:45

References:

Australian bpay pokies https://community.likpi.com/d/37-bpay-casinos-australia-2026-full-list-of-casinos-accepting-bpay

sikhforum.de · 2026-09-03 11:42

References:

Bank wire online casino australia https://sikhforum.de/forum/topic/a-clear-guide-to-best-bank-wire-casinos-australia/

allunderground.com · 2026-09-03 21:14

References:

Fast EFT payouts Australia https://allunderground.com/forum/topic/is-low-deposit-eft-casino-worth-it/

bling.pholce.com · 2026-09-04 04:20

References:

$1 minimum deposit casino neosurf australia https://bling.pholce.com/forum/topic/the-simple-guide-to-1-dollar-deposit-casino-neosurf-australia/

https://forum.radxa.com/ · 2026-09-04 16:59

References:

MiFinity deposit pokies Australia https://forum.radxa.com/t/best-mifinity-casinos-in-australia-for-august-2026/31380

Trustly Instant Banking · 2026-09-04 17:58

References:

Online Casino Trustly Bonus https://pv4wegs.de/forum/topic/was-denkst-du-von-trustly-casino-spielautomaten/

klarna sofortüberweisung casino · 2026-09-04 18:41

References:

Seriöse sofort casinos https://community.posterit.in/d/16-online-slots-sofortuberweisung-kurz-bewertet

pahlawan4d · 2026-09-04 21:20

[548]pahlawan4d Official Login | Best Online Slots & Fast Payouts MY,pahlawan4d offers a seamless experience with a dedicated app download and expert guides on how to play 4d lottery. Enjoy secure gaming and join the action today. visit: pahlawan4d