SQL TypeError: can't concat tuple to bytes

Question

Running this piece of code returns a type error of 'can't concat tuple to bytes', but in my codes I don't see where the bytes are coming from, hence unsure how to fix my codes. Any pointers on which line of codes is in the form of bytes?

def array2python():

     mfcc = "US"
     number = 8 #could be any number from 0 to 9
     t = (number, mfcc)
     conn = pymysql.connect( host=hostname, port = port, user=username, passwd=password, db=database, charset='utf8mb4', cursorclass=pymysql.cursors.DictCursor )
     cur = conn.cursor()
     query = ('INSERT INTO audioFiles VALUES (?,?)', t)
     cur.execute(query)
     conn.close()

alecxe · Accepted Answer · 2017-12-24 02:25:54Z

7

The problem is on this line:

query = ('INSERT INTO audioFiles VALUES (?,?)', t)

You are defining the query as a tuple which then execute() fails to understand.

You mean to do:

query = 'INSERT INTO audioFiles VALUES (?,?)'
cur.execute(query, t)

And, I think you need to use %s as a placeholder:

query = 'INSERT INTO audioFiles VALUES (%s,%s)'
cur.execute(query, t)

answered Dec 24, 2017 at 2:25

alecxe

476k127 gold badges1.1k silver badges1.2k bronze badges

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

2 Comments

jc76 Over a year ago

I suspected that I need to do %s but would this invite SQL injections?

alecxe Over a year ago

@jc76 if you use these %s placeholders to do string formatting - then, ys. But, in our case we are using them as query placeholders and passing parameters in a second argument to execute(). Thanks.

Collectives™ on Stack Overflow

SQL TypeError: can't concat tuple to bytes

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