python list in sql query as parameter [duplicate]

by

Answers so far have been templating the values into a plain SQL string. That’s absolutely fine for integers, but if we wanted to do it for strings we get the escaping issue.

Here’s a variant using a parameterised query that would work for both:

placeholder="?" # For SQLite. See DBAPI paramstyle.
placeholders=", ".join(placeholder for unused in l)
query= 'SELECT name FROM students WHERE id IN (%s)' % placeholders
cursor.execute(query, l)

More Related Contents:

  1. SQL / Pandas equivalent
  2. Pandas read_sql with parameters
  3. Pandas DENSE RANK
  4. How to put parameterized sql query into variable and then execute in Python?
  5. Not all parameters were used in the SQL statement (Python, MySQL)
  6. How can I get dict from sqlite query?
  7. pyodbc – How to perform a select statement using a variable for a parameter
  8. Using a Python dict for a SQL INSERT statement
  9. Pandas left outer join multiple dataframes on multiple columns
  10. LEFT JOIN Django ORM
  11. Get data from pandas into a SQL server with PYODBC
  12. reading external sql script in python
  13. Python, SQLAlchemy pass parameters in connection.execute
  14. Insert list into my database using Python [duplicate]
  15. Complex foreign key constraint in SQLAlchemy
  16. How to log all sql queries in Django?
  17. Python SQL query string formatting
  18. Pandas query function not working with spaces in column names
  19. How to get rows which match a list of 3-tuples conditions with SQLAlchemy
  20. Dynamic SQL Queries with Python and mySQL
  21. SQLAlchemy: how to filter date field?
  22. What is an efficient way of inserting thousands of records into an SQLite table using Django?
  23. How to execute “left outer join” in SqlAlchemy
  24. SQL join or R’s merge() function in NumPy?
  25. Getting random row through SQLAlchemy
  26. Select NULL Values in SQLAlchemy
  27. How to check the existence of a row in SQLite with Python?
  28. How to quote a string value explicitly (Python DB API/Psycopg2)
  29. Pandas analogue to SQL MINUS / EXCEPT operator, using multiple columns
  30. How to delete a record in Django models?

Leave a Comment