Unable to insert multiple rows to sql table from python

Question

Even though I pass a list as params I am getting the below error while executing the query

TypeError: ('Params must be in a list, tuple, or Row', 'HY000')

I am trying to pass multiple rows to sql table using executemany

Please find my code below and help, I am new to python.

query = """INSERT INTO TableTest (Summary) Values (%s)"""
val = [('SPHXNORF2ASW1'),('CHNSIRSDB1USAA'),('NKOLGTPRAVPNVM'),('STAMHO3WANCEG'),('SPHXNORWANCEG1'),('SPHXNORWANCE'),('STAMHO3WANCEG')]
       
     
                 
      
cursor = conn.cursor()

cursor.executemany(query,val)

conn.commit()   ```

Kris · Accepted Answer · 2021-10-20 14:31:04Z

2

In python, putting a value inside '()' does not make it tuple. So, this code

val = [('SPHXNORF2ASW1'),('CHNSIRSDB1USAA'),('NKOLGTPRAVPNVM'),('STAMHO3WANCEG'),('SPHXNORWANCEG1'),('SPHXNORWANCE'),('STAMHO3WANCEG')]

will be converted to

['SPHXNORF2ASW1', 'CHNSIRSDB1USAA', 'NKOLGTPRAVPNVM', 'STAMHO3WANCEG', 'SPHXNORWANCEG1', 'SPHXNORWANCE', 'STAMHO3WANCEG']

If you want to specify it as a tuple, add a trailing comma like below or use '[]' instead of tuple.

Use:

val = [('SPHXNORF2ASW1',),('CHNSIRSDB1USAA',),('NKOLGTPRAVPNVM',),('STAMHO3WANCEG',),('SPHXNORWANCEG1',),('SPHXNORWANCE',),('STAMHO3WANCEG',)]

Or:

[ ['SPHXNORF2ASW1'], ['CHNSIRSDB1USAA'], ['NKOLGTPRAVPNVM'], ['STAMHO3WANCEG'], ['SPHXNORWANCEG1'], ['SPHXNORWANCE'], ['STAMHO3WANCEG']]

answered Oct 20, 2021 at 14:31

Kris

8,8984 gold badges45 silver badges71 bronze badges

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

2 Comments

Arun Ezhil Over a year ago

Thank you so much for sharing the knowledge you got, it worked for me.

Kris Over a year ago

Good to know it helped you. You can accept it as the answer if the issue was resolved

Collectives™ on Stack Overflow

Unable to insert multiple rows to sql table from python

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related