Using Python variables in MySQL INSERT statement
Hi all,
I'm having trouble getting local Python variables to work in my INSERT statements:
So far, I've opened a connection to my database, which contains a table called data(3 columns):
currtime = "Jun 03 11:11:06 2008"
currtemp = 75
currsat = 60
cur.execute('INSERT INTO data (time,temp,sat) VALUES (currtime,currtemp,currsat)')
However, this gives me an error. How can I get variables to work?
Subject
Written By
Posted
Using Python variables in MySQL INSERT statement
June 03, 2008 11:58AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.