python - python 中 mySQL 的最后一个值(查询)

Question

尝试从 Raspberry Pi 上的 MySQL 获取最后一个值。不知道为什么我的简单代码不起作用，在 row =cursor.fetchone() 处的“execute() first”处给出错误。

这是我的代码:

# External module imports
import time
import os
import datetime
import MySQLdb

# Connect to mysql
db=MySQLdb.connect("localhost","zikmir","gforce","temp_database")
# Prepair a cursor    
cursor=db.cursor()

# Select three columns, id, time and temp from table time_temp
cursor.execute = ("SELECT id, time, temp FROM time_temp")
# ID is autoincremented value, time is in TIME and temp is float 

row = cursor.fetchone()
# Trying to store the last result in variable row

# Close cursor and database
cursor.close()
db.close()

Answer 1

观察cursor.execute = ("SELECT id, time, temp FROM time_temp")中的=。它应该是 cursor.execute("SELECT...")