python - python输出十进制而不是整数中的平均sql查询

Question

代码链接

我想在我的数据库表中输出整数。顺便说一句，我的值是整数。

import mysql.connector
import datetime
from datetime import timedelta 

mydb=mysql.connector.connect(host='localhost',user="user",passwd="",database="test")

sessionID= "SE311"
datetime1=datetime.datetime(2020,5,19,22,40,00)

for loop in range(4):

    sqlform = "SELECT AVG(attentionP) FROM attentionstudent WHERE sessionID=%s AND min=%s"
    datetime1=datetime1+timedelta(minutes=1)

    data_tuple=(sessionID,datetime1)

    mycursor = mydb.cursor()
    mycursor.execute(sqlform,data_tuple)
    records = mycursor.fetchall()
    print(records)

标签： pythonmysqlsql