title: Python MySQLdb not inserting data
body: <p>ubuntu version: 12.10 <br>
  mysql server version: 5.5.29-0 <br>
  python version: 2.7</p>
  
  <p>I am trying to use MySQLdb to insert data into my localhost mysql server. I don't get any errors when I run the script but the data isn't enter into my table. I view tables with phpmyadmin.</p>
  
  <p>I tried going back to basics and following a tutorial but same result. The weird thing is that I can create and delete tables but not enter data.</p>
  
  <p>The code is from the tutorial even reports that 4 rows were inserted. What is preventing data from being entered into the table when the script reports everything is fine??</p>
  
  <pre><code>cursor = conn.cursor () 
  cursor.execute ("DROP TABLE IF EXISTS animal") 
  cursor.execute (""" 
          CREATE TABLE animal 
          ( 
              name CHAR(40), 
              category CHAR(40) 
          ) 
      """) 
  cursor.execute (""" 
          INSERT INTO animal (name, category) 
          VALUES 
              ('snake', 'reptile'), 
              ('frog', 'amphibian'), 
              ('tuna', 'fish'), 
              ('racoon', 'mammal') 
      """) 
  print "%d rows were inserted" % cursor.rowcount 
  </code></pre>