How to see the real SQL query in Python cursor.execute using pyodbc and MS-Access

by

It differs by driver. Here are two examples:

import MySQLdb
mc = MySQLdb.connect()
r = mc.cursor()
r.execute('select %s, %s', ("foo", 2))
r._executed
"select 'foo', 2"

import psycopg2
pc = psycopg2.connect()
r = pc.cursor()
r.execute('select %s, %s', ('foo', 2))
r.query
"select E'foo', 2"

More Related Contents:

  1. Working with an Access database in Python on non-Windows platform (Linux or Mac)
  2. PYODBC–Data source name not found and no default driver specified
  3. pyodbc – How to perform a select statement using a variable for a parameter
  4. Get data from pandas into a SQL server with PYODBC
  5. “Data source name not found and no default driver specified” with Access ODBC
  6. pyodbc insert into sql
  7. python pandas to_sql with sqlalchemy : how to speed up exporting to MS SQL?
  8. pyodbc the sql contains 0 parameter markers but 1 parameters were supplied’ ‘hy000’
  9. Remote connection to MS SQL – Error using pyodbc vs success using SQL Server Management Studio
  10. How to use variables in SQL statement in Python?
  11. How to speed up bulk insert to MS SQL Server using pyodbc
  12. How to put parameterized sql query into variable and then execute in Python?
  13. python pip specify a library directory and an include directory
  14. How do I get a raw, compiled SQL query from a SQLAlchemy expression?
  15. Filtering a Pyspark DataFrame with SQL-like IN clause
  16. Using a Python dict for a SQL INSERT statement
  17. Pandas left outer join multiple dataframes on multiple columns
  18. Writing a csv file into SQL Server database using python
  19. Parsing SQL with Python
  20. Insert list into my database using Python [duplicate]
  21. Complex foreign key constraint in SQLAlchemy
  22. Is this Python code vulnerable to SQL injection? (SQLite3)
  23. Python SQL query string formatting
  24. pysqlite: Placeholder substitution for column or table names?
  25. SQLAlchemy: how to filter date field?
  26. How to execute “left outer join” in SqlAlchemy
  27. how to deal with .mdb access files with python
  28. What is the best way to access stored procedures in Django’s ORM
  29. Python SQLite3 SQL Injection Vulnerable Code
  30. sql.h not found when installing PyODBC on Heroku

Leave a Comment