Mysql insert with Python Could not Process Parameters [duplicate]

Question

This question already has answers here:

How can I use variables in an SQL statement in Python? (6 answers)

Python MySQL connector - unread result found when using fetchone (10 answers)

Closed 2 years ago.

This post was edited and submitted for review 2 years ago and failed to reopen the post:

Original close reason(s) were not resolved

I'm working on a function in python that reads values from MySql. When I insert using the same format there are no errors but when I select it gives me the error mysql.connector.errors.ProgrammingError: Could not process parameters: str(555), it must be of type list, tuple or dict Here is my code that is giving the error

cursor.execute('SELECT * FROM LIBS')
            result = cursor.fetchall()
            for row in result:
                user_id = row[0]
                song_id = row[1]
                if(user_id == userno):
                    cursor.execute("SELECT s_title FROM SONG WHERE s_id = (%s)", (song_id))
                    print(row[1])

What I don't understand is when I use the exact same format for INSERT with (%s) there are no errors

I tried adding a comma inside the song_id and then running them as cursor.execute("SELECT s_title FROM SONG WHERE s_id = (%s)", (song_id,)) but I got the error mysql.connector.errors.InternalError: Unread result found.

I added a second duplicate link to explain the "Unread result found" error message. — snakecharmerb
– snakecharmerb, Commented Dec 12, 2022 at 17:05

Plagon · Accepted Answer · 2022-12-10 16:44:19Z

0

params must be a list, tuple or dict (see docs)

cursor.execute("SELECT s_title FROM SONG WHERE s_id = (%s)", (song_id,))

Note the comma after song_id. Without the comma, it's just a str and not a tuple. This is only necessary for creating tuples with one element.

answered Dec 10, 2022 at 16:44

Plagon

3,1651 gold badge14 silver badges27 bronze badges

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

2 Comments

Andrew Over a year ago

Doing it like that gives me error unread result found

Plagon Over a year ago

Yeah, that's because you are not using the cursor properly. You are executing a statement, but do not consume the result before executing another statement. You can set buffered=True when creating the cursor.

Collectives™ on Stack Overflow

Mysql insert with Python Could not Process Parameters [duplicate]

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related