inserting data into MYSQL database using python

Question

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.

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

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

Please help me out

John Gaines Jr. · Accepted Answer · 2012-04-19 22:07:08Z

1

You need to escape the %M, %d and %Y as in:

"INSERT INTO md_patentinfo (patentno, filed) VALUES ('%s',STR_TO_DATE('%s','%%M %%d,%%Y'))" % ('123','Apr 14,2012')

answered Apr 19, 2012 at 22:07

John Gaines Jr.

11.6k1 gold badge28 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Eyal Ch Over a year ago

when i use this format in .execute(query) i get: not enough arguments for format string

sinelaw · Accepted Answer · 2012-07-31 17:32:49Z

1

Your format string has five arguments (each '%something' is an argument). You probably want to escape the %M, %d%Y part:

"INSERT INTO md_patentinfo (patentno, filed) VALUES ('%s',STR_TO_DATE('%s','%%M %%d,%%Y'))" % (patent_number,issue_date)

edited Jul 31, 2012 at 17:32

answered Apr 19, 2012 at 22:12

sinelaw

16.6k4 gold badges55 silver badges82 bronze badges

Collectives™ on Stack Overflow

inserting data into MYSQL database using python

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related