Pymysql Insert Into not working

eclipse, mysql, pymysql, python, python-2.7

Solution

Did you commit it? `conn.commit()`

Problem

I'm running this from PyDev in Eclipse... ``` import pymysql conn = pymysql.connect(host='localhost', port=3306, user='userid', passwd='password', db='fan') cur = conn.cursor() print "writing to db" cur.execute("INSERT INTO cbs_transactions(leagueID) VALUES ('test val')") print "wrote to db" ``` The result is, at the top of the Console it says C:...test.py, and in the Console: writing to db wrote to db So it's not terminating until after the execute command. But when I look in the table in MySQL it's empty. A record did not get inserted. First off, why isn't it writing the record. Second, how can I see a log or error to see what happened. Usually there should be some kind of error in red if the code fails.

Original source

Related problems