title: Pymysql Insert Into not working
body: <p>I'm running this from PyDev in Eclipse...</p>
  
  <pre><code>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"
  </code></pre>
  
  <p>The result is, at the top of the Console it says  C:...test.py, and in the Console:</p>
  
  <p>writing to db
  wrote to db</p>
  
  <p>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.</p>
  
  <p>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.</p>