- 论坛徽章:
- 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
邮件发送脚本
#!/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())
邮件接收到的内容:
['122000000995']
['122000000996']
['10907547']
['10907546']
['30501115']
['190050033945']
怎么样让发送出来的成
122000000995
122000000996
10907547
10907546
30501115
190050033945 |
|