title: MYSQL and python error
body: <p>I want to insert data in MYSQL database using python 
  here my code </p>
  
  <pre><code>import MySQLdb
  #connect to db
  db= MySQLdb.connect(host= "localhost",
                user="root",
                passwd="newpassword",
                db="new_schema")
  #setup cursor
  cursor = db.cursor()
  #create anooog1 table
  cursor.execute("DROP TABLE IF EXISTS try")
  sql = """CREATE TABLE try (
        COL1 INT,            COL2 INT )"""
  cursor.execute(sql)
  
  
  #insert to table
  cursor.execute("""INSERT INTO try VALUES (%s,%s)""",(188,90))
  db.commit()   
  db.rollback()
  #show table
  cursor.execute("""SELECT * FROM try""")
  
  print cursor.fetchall()
  db.close()
  </code></pre>
  
  <p>but the error is in my sql</p>
  
  <pre><code>Error: `new_schema`.`try`: table data is not editable because there is no primary key defined for the table ...
  </code></pre>
  
  <p>What shall I do?</p>