mysql em_Python在主体Emai中发送MySQL查询

你好吗！我需要帮助。我有一个脚本，连接到mysql并打印一个查询。在from __future__ import print_function

import MySQLdb as my

db = my.connect(host="127.0.0.1",

user="root",

passwd="",

db="gs"

)

cursor = db.cursor()

sql = "

SELECT c.titulo as Control

, IF(c.responsable=1, 'TISO','FISO') AS Responsable

, case r.mes when 1 then 'Enero' when 2 then 'Febrero' when 3 then 'Marzo' when 4 then 'Abril' when 5 then 'Mayo' when 6 then 'Junio' when 7 then 'Julio' when 8 then 'Agosto' when 9 then 'Septiembre' when 10 then 'Octubre' when 11 then 'Noviembre' when 12 then 'Diciembre' end AS Mes

FROM controles AS c

JOIN referencias as r

ON c.id_control = r.id_control

WHERE r.mes <= MONTH(CURRENT_DATE())

AND r.ano = YEAR(CURRENT_DATE())

ORDER

BY c.responsable

, c.titulo

, r.mes ASC

"

number_of_rows = cursor.execute(sql)

result = cursor.fetchall()

fiso = 0

tiso = 0

for row in result:

if (row[1]=='TISO' and tiso == 1):

print(row[1], row[0],' | ',row[2])

if (row[1]=='TISO' and tiso == 0):

print ("--------------------------------------------------")

print (" Controles TISO ")

print ("--------------------------------------------------")

tiso = 1

print(row[1], row[0],' | ',row[2])

if (row[1]=='FISO' and fiso == 1):

print(row[1], row[0],' | ',row[2])

if (row[1]=='FISO' and fiso == 0):

print ("--------------------------------------------------")

print (" Controles FISO ")

print ("--------------------------------------------------")

fiso = 1

print(row[1], row[0],' | 'row[2])

db.close()

结果在这里

我如何将这个结果添加到电子邮件正文中？在

我将与这个脚本合并

^{pr2}$

你能帮我吗？我被训练将每一行添加到文本变量，但我不知道如何管理元组。在

谢谢各位！在