Python and MySQLdb: substitution of table resulting in syntax error

by

Parameter substitution in the DB API is only for values – not tables or fields. You’ll need to use normal string substitution for those:

selectQ ="""SELECT * FROM  %s WHERE %s = %%s;""" % (self.table,self.columnSpecName)
self.db.execute(selectQ,(idKey,))
return self.db.store_result()

Note that the value placeholder has a double % – this is so that it’s left alone by the initial string substitution.

More Related Contents:

  1. Installing specific package version with pip
  2. Visibility of global variables in imported modules
  3. pip install mysql-python fails with EnvironmentError: mysql_config not found
  4. “Cannot open include file: ‘config-win.h’: No such file or directory” while installing mysql-python
  5. Python mysqldb: Library not loaded: libmysqlclient.18.dylib
  6. Database does not update automatically with MySQL and Python
  7. mysql_config not found when installing mysqldb python interface
  8. mysql-python install error: Cannot open include file ‘config-win.h’
  9. Replacing Pandas or Numpy Nan with a None to use with MysqlDB
  10. Install mysql-python (Windows)
  11. When to close cursors using MySQLdb
  12. Installing mysqlclient in Python 3.6 in windows
  13. Python 3.4.0 with MySQL database
  14. How can I use executemany to insert into MySQL a list of dictionaries in Python
  15. Python MySQLdb execute table variable [duplicate]
  16. ImportError: No module named MySQLdb
  17. Print the actual query MySQLdb runs?
  18. cursor.fetchall() vs list(cursor) in Python
  19. Can’t install mysql-python (newer versions) in Windows
  20. Python MySQLdb: connection.close() VS. cursor.close()
  21. Dynamic SQL Queries with Python and mySQL
  22. What’s the difference between MySQLdb, mysqlclient and MySQL connector/Python?
  23. Python MySQLDB: Get the result of fetchall in a list
  24. How to use python mysqldb to insert many rows at once
  25. About MySQLdb conn.autocommit(True)
  26. ‘pip install MySQL-python’ fails with ‘IndexError’
  27. What is PyMySQL and how does it differ from MySQLdb? Can it affect Django deployment?
  28. ModuleNotFoundError: No module named ‘MySQLdb’
  29. How to disable query cache with mysql.connector
  30. What’s the most efficient way to convert a MySQL result set to a NumPy array?

Leave a Comment