What is wrong with my python mysql query?

Question

MySQL

I seem to somehow misunderstand the idea of ​​%s parameters, but it does not reach me why this construction does not work:

cursor.execute("select ID,LINK from LINKS where USERID=%s ",(id))

mistake:

(42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '%s' at line 1

Answer 1

By the missing comma after id, you misunderstand the idea of ​​tuples.