Last value from mySQL in python (Query)

Question

Trying to get the last value from MySQL on Raspberry Pi. No idea why my simple code wont work, gives error at "execute() first" at row = cursor.fetchone().

Here is my code:

# 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()

Looks correct: It will fail however if there is no data in the table time_temp — Norbert
– Norbert, Commented Apr 30, 2017 at 3:41
@NorbertvanNobelen I do have data in the table, I'm pushing data and also fetching it successfully at my website in php. www.ziks.ca — Zik Mir
– Zik Mir, Commented Apr 30, 2017 at 4:10

user2722968 · Accepted Answer · 2017-04-30 20:20:16Z

1

watch the = incursor.execute = ("SELECT id, time, temp FROM time_temp"). It should read cursor.execute("SELECT...")

answered Apr 30, 2017 at 20:20

user2722968

17.4k5 gold badges58 silver badges77 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Last value from mySQL in python (Query)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related