title: Python MySql Insert not working
body: <p>I am using python MySQL API to connect to Mysql database from python program. I am facing a problem from few days. I am unable to insert records into the database and dont know whats the reason. Here is the way i connect and insert records into the database.</p>
  
  <pre><code>db = MySQLdb.connect("localhost","root","padmaramulu","pdfsearch" )
  cursor = db.cursor()
  #cursor.execute("""CREATE TABLE IF NOT EXISTS documents (docid INT NOT NULL ,PRIMARY KEY(docid),docname CHAR(30)) engine=innodb""")
  temp = "hello";number = 2;
  cursor.execute( 'insert into documents(docid,docname) values("%d","%s")' % (number,temp) )
  db.close()
  </code></pre>
  
  <p>Why is it so?</p>