I have a problem using the MySQLdb library. I'm trying to insert values into my table but MySQL isn't showing them. What's more strange is the primary key is changing when I manually insert values using command prompt.
Here's an example:
'786', '2011-02-16 14:52:38', NULL '787', '2011-02-16 14:52:52', NULL '792', '2011-02-16 14:53:25', NULL
I manually insert some value at 786 and 787 (primary key), then I run my python script, stopping it after I got 4 values. I type in 'SELECT * from table' and I see no changes. Then I inset another value (manually) and it shows a new primary key '792'. It seems like the python script is deleting things...
Here's my python code:
try: conn = MySQLdb.connect(host = "127.0.0.1", user = "root", passwd = "eBao1234", db = "test") cursor = conn.cursor() print 'data base connected' try: while 1: localtime = time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()) i = i + 1 aRead = ser.readline() aSplit = aRead.split(",") if aSplit == "t": print str(i) + ", " + localtime + ", " + aSplit tableName = "sampdb" dbquery = "INSERT INTO %s (timestamp, tempReading) VALUES (NOW(), %s);" % (tableName, aSplit) cursor.execute(dbquery) except KeyboardInterrupt: ser.close() #csvResults.close() #cursor.close() #conn.close() print "\nInterrupted." raw_input("Press enter to exit.") except Exception,e: print str(e) print 'error connecting to database' cursor.close() conn.close()