Insert each element of a list into a separate column in mysql python

Question

I want to be able to iterate thru a list in python and insert each element in a separate column on a table in MySQL DB.

i have this syntax which i also found here :

 jobdata = [sampledata,sampledata1,sampledata2]

 params = ['?' for item in jobdata]
 sql   = 'INSERT INTO refactorBatch (runnum, hold, processtn) VALUES (%s);' % ','.join(params)
 cursor.execute(sql, list)
 cnx.commit()

But i am having this error:

File "C:\Python27\lib\site-packages\mysql\connector\cursor.py", line 355, in _process_params
    "Failed processing format-parameters; %s" % err)
mysql.connector.errors.ProgrammingError: Failed processing format-parameters; argument 2 to map() must support iteration

Did i miss something here?

Thank you!

Zach Gates · Accepted Answer · 2015-03-09 04:01:04Z

2

Most likely, it is the line

cursor.execute(sql, list)

which is attempting to use the builtin list type as an argument.

answered Mar 9, 2015 at 4:01

Zach Gates

4,1651 gold badge29 silver badges52 bronze badges

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

1 Comment

ellabells Over a year ago

oh wow. thanks! got rid of the error. but another one came up @zachgates mysql.connector.errors.ProgrammingError: Wrong number of arguments during string formatting

Collectives™ on Stack Overflow

Insert each element of a list into a separate column in mysql python

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related