Try this: for x in data: value = “test” query = “INSERT INTO test (serial) VALUES (%s)” cursor.execute(query,(value,)) print(“Inserted”,cursor.rowcount,”row(s) of data.”) Since you are using mysql module, cursor.execute requires a sql query and a tuple as parameters
use dbb.commit() after curb.execute (“UPDATE RadioGroups SET CurrentState=1 WHERE RadioID=11”) to commit all the changes that you ‘loaded’ into the mysql server
Change your funcursor.execute(query, uName) call to: funcursor.execute(query, (uName, )) The second argument in execute takes a list/tuple of strings, not a string. The above call creates the tuple before passing in the string to execute, so no error is thrown. The reason why execute takes a list/tuple of strings is because it does not know … Read more