Python MySQLdb execute table variable [duplicate]

by

You can’t use a parameter for the table name in the execute call. You’ll need to use normal Python string interpolation for that:

sql = "SELECT * FROM %s" % table
cursor.execute(sql)

Naturally, you’ll need to be extra careful if the table name is coming from user input. To mitigate SQL injection, validate the table name against a list of valid names.

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. How to insert pandas dataframe via mysqldb into database?
  10. Replacing Pandas or Numpy Nan with a None to use with MysqlDB
  11. Install mysql-python (Windows)
  12. When to close cursors using MySQLdb
  13. Installing mysqlclient in Python 3.6 in windows
  14. Python MYSQL update statement
  15. Python 3.4.0 with MySQL database
  16. How can I use executemany to insert into MySQL a list of dictionaries in Python
  17. Python and MySQLdb: substitution of table resulting in syntax error
  18. MySQL: Get column name or alias from query
  19. ImportError: No module named MySQLdb
  20. Print the actual query MySQLdb runs?
  21. cursor.fetchall() vs list(cursor) in Python
  22. Can’t install mysql-python (newer versions) in Windows
  23. Python MySQLdb: connection.close() VS. cursor.close()
  24. Dynamic SQL Queries with Python and mySQL
  25. What’s the difference between MySQLdb, mysqlclient and MySQL connector/Python?
  26. How to use python mysqldb to insert many rows at once
  27. About MySQLdb conn.autocommit(True)
  28. What is PyMySQL and how does it differ from MySQLdb? Can it affect Django deployment?
  29. ModuleNotFoundError: No module named ‘MySQLdb’
  30. How to disable query cache with mysql.connector

Leave a Comment