('the Sql Contains 0 Parameter Markers, But 50 Parameters Were Supplied', 'hy000') Or Typeerror: 'tuple' Object Is Not Callable

import pyodbc,nltk,array cnxn = pyodbc.connect('Driver={MySQL ODBC 5.1 Driver};Server=127.0.0.1;Port=3306;Database=information_schema;User=root; Password=1234;Option=3;') cursor =

Solution 1:

The method executemany(sql, seq_of_parameters) executes the same SQL statement multiple times for a set of parameters. Therefore, the second argument, seq_of_parameters, must be a sequence of parameter tuples, not just a single parameter tuple:

cursor.executemany("update sampledata SET POS = ? where SRNO = ?", [(x[a], a)])

If you pass just one tuple, the cursor will assume that the first item, x[a], is a tuple of parameters. I guess it is a string of 50 characters and gets interpreted as a sequence of 50 parameters, whereas the SQL string only expects 2.

Furthermore, notice that I used ? as the placeholder symbol instead of %s, since the latter seems to be unsupported by PyODBC, as it reported that it expected 0 parameters.

In your case, you might want to use the execute() method in the loop, since you only want to run the statement once per iteration:

cursor.execute("update sampledata SET POS = ? where SRNO = ?", (x[a], a))