MySQL Connector could not process parameters

by

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

More Related Contents:

  1. Python mySQL Update, Working but not updating table
  2. mysql to pdf – python or ruby [closed]
  3. Installing specific package version with pip
  4. How can I connect to MySQL in Python 3 on Windows?
  5. Python & MySql: Unicode and Encoding
  6. Authentication plugin ‘caching_sha2_password’ is not supported
  7. How to disable SQLAlchemy caching?
  8. Setting Django up to use MySQL
  9. memory-efficient built-in SqlAlchemy iterator/generator?
  10. How can I insert data into a MySQL database?
  11. How to use MySQLdb with Python and Django in OSX 10.6?
  12. When to close cursors using MySQLdb
  13. How to enable MySQL client auto re-connect with MySQLdb?
  14. How to build a flask application around an already existing database?
  15. Python MySql Insert not working
  16. What is the best solution for database connection pooling in python?
  17. Python: MySQLdb and “Library not loaded: libmysqlclient.16.dylib”
  18. How to filter (or replace) unicode characters that would take more than 3 bytes in UTF-8?
  19. ImportError: No module named ‘MySQL’
  20. mysql-python installation problems (on mac os x lion)
  21. How to make an Inner Join in django?
  22. Dynamic SQL Queries with Python and mySQL
  23. Simple Subquery with OuterRef
  24. Python JSON encoder to support datetime?
  25. django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module: No module named MySQLdb
  26. pymysql fetchall() results as dictionary?
  27. Install mysqlclient for Django Python on Mac OS X Sierra
  28. ‘pip install MySQL-python’ fails with ‘IndexError’
  29. How to insert / retrieve a file stored as a BLOB in a MySQL db using python
  30. How to make mysql connection that requires CA-CERT with sqlalchemy or SQLObject

Leave a Comment