Not all parameters were used in the SQL statement (Python, MySQL)

by

The parameter marker is %s not %d.

add_user = """INSERT INTO DB.tbluser 
              (username, department, startyear, currentpos, link) 
              VALUES (%s, %s, %s, %s, %s)"""

Note that the parameter markers used by mysql.connector may look the same as the %s used in Python string formatting but the relationship is only coincidental. Some database adapters like oursql and sqlite3 use ? as the parameter marker instead of %s.

More Related Contents:

  1. pip install mysqlclient returns “fatal error C1083: Cannot open file: ‘mysql.h’: No such file or directory
  2. How do I get a raw, compiled SQL query from a SQLAlchemy expression?
  3. Using a Python dict for a SQL INSERT statement
  4. Insert list into my database using Python [duplicate]
  5. Python Pandas write to sql with NaN values
  6. Dynamic SQL Queries with Python and mySQL
  7. mysql to pdf – python or ruby [closed]
  8. SQL / Pandas equivalent
  9. Installing specific package version with pip
  10. Pandas read_sql with parameters
  11. Install mysql-python (Windows)
  12. Installing MySQL Python on Mac OS X
  13. pyodbc – How to perform a select statement using a variable for a parameter
  14. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock
  15. SQLAlchemy ON DUPLICATE KEY UPDATE
  16. Python 3.4.0 with MySQL database
  17. reading external sql script in python
  18. How to efficiently use MySQLDB SScursor?
  19. How to run Django’s test database only in memory?
  20. Using MySQL in Flask
  21. Repeated MySQL queries from Python return the same data [duplicate]
  22. Can one use the Django database layer outside of Django?
  23. Python mySQL Update, Working but not updating table
  24. Python import MySQLdb error – Mac 10.6
  25. mysql-python installation problems (on mac os x lion)
  26. How to make an Inner Join in django?
  27. Python JSON encoder to support datetime?
  28. SQL join or R’s merge() function in NumPy?
  29. Python issue:Unable to find vcvarsall.bat [duplicate]
  30. How to delete a record in Django models?

Leave a Comment