title: %d format a number is required not str
body: <p>I have a table named tablename with idno as primary kry. I want the row to be deleted if the user specifies the idno in the table.
  Here are my codes:</p>
  
  <pre><code>data3=raw_input("Enter the idno to del :",)
  mydata=cursor.execute("DELETE FROM tablename where idno=%d", data3)
  db.commit()
  </code></pre>
  
  <p>I'm getting this error:</p>
  
  <blockquote>
    <p>Traceback (most recent call last):   File "C:\Python27\trertr.py",
    line 50, in 
        mydata=cursor.execute("DELETE FROM tablename where idno=%d", data3)   File "C:\Python27\lib\site-packages\MySQLdb\cursors.py", line
    187, in execute
        query = query % tuple([db.literal(item) for item in args]) TypeError: %d format: a number is required, not str</p>
  </blockquote>