Problem with python prepared stmt parameter passing

Question

File C:UsersUserAppDataLocalProgramsPythonPython37libsite-packagesmysqlconnectorcursor.py, line 1149, in execute elif len(self._prepared[parameters]) != len(params): TypeError: object of type int has no len()

Answer 1

The problem is python make error when we pass single parameter we need to put comma(,) at the end of first parameter. like the follwoing

input=(customerId,)
cursor.execute(sql, input)