inserting data into MYSQL database using python
<p>I am trying to insert data into MYSQL database using a python script and when i execute my program i get an error "Not enough arguments for format string" at the following line.</p>

<pre><code>_cursor.execute("INSERT INTO `md_patentinfo` (patentno, filed) 
       VALUES ('%s',STR_TO_DATE('%s','%M %d,%Y'))" %(patent_number,issue_date))
</code></pre>

<p><strong>MORE INFO ON THE ABOVE LINE :</strong>
in the above line i am inserting <code>patent number</code> and <code>Issue date</code> into my table and i am using the <code>STR_TO_DATE</code> to convert the date value in <code>%B %d,%Y</code> format to <code>%M,%d,%Y</code>.</p>

<p>Please help me out</p>
