- 論壇徽章:
- 1
|
本帖最后由 Goun1314 于 2016-01-14 10:00 編輯
mysql查詢腳本:
cur = conn.cursor()
cur.execute("select * from test;")
cur.close()
conn.close()
if __name__ == '__main__':
for i in cur:
a=re.findall('([0-9]+)',str(i))
print a
郵件發(fā)送腳本
#!/usr/bin/env python
# -*- coding:utf-8 -*-
import sendmail
import os
def c():
a=os.popen("python mysql.py")
c=a.read()
return c
sendmail.send_mail("xxxxx@qq.com","報告",c())
郵件接收到的內(nèi)容:
['122000000995']
['122000000996']
['10907547']
['10907546']
['30501115']
['190050033945']
怎么樣讓發(fā)送出來的成
122000000995
122000000996
10907547
10907546
30501115
190050033945 |
|