How do I use SQL parameters with python?

by

After creating a connection object db:

cursor = db.execute('SELECT * FROM Customer WHERE CustomerID = %s', [customer_id])

then use any of the fetch... methods of the resulting cursor object.

Don’t be fooled by the %s part: this is NOT string formatting, it’s parameter substitution (different DB API modules use different syntax for parameter substitution — pymssql just happens to use the unfortunate %s!-).

More Related Contents:

  1. How to configure pymssql with SSL support on Ubuntu?
  2. Binning a column with Python Pandas
  3. multiple prints on the same line in Python
  4. setting y-axis limit in matplotlib
  5. Why Python recursive function returns None
  6. Python: make eval safe [duplicate]
  7. C and Python – different behaviour of the modulo (%) operation
  8. Why do I get a “referenced before assignment” error when assigning to a global variable in a function?
  9. How can I search a word in a Word 2007 .docx file?
  10. Keep a subprocess alive and keep giving it commands? Python
  11. Can you perform multi-threaded tasks within Django?
  12. How do I print parameters of multiple objects in table form? [duplicate]
  13. What does the “r” in pythons re.compile(r’ pattern flags’) mean?
  14. RuntimeError: working outside of application context
  15. Only index needed: enumerate or (x)range?
  16. Pythonic way to resolve circular import statements?
  17. logging with filters
  18. how can i show an irrational number to 100 decimal places in python?
  19. How locate the pseudo-element ::before using Selenium Python
  20. I’ve got an error when trying to create sound using pygame
  21. How can my Model primary key start with a specific number?
  22. Why do these list methods (append, sort, extend, remove, clear, reverse) return None rather than the resulting list?
  23. How do I read text from the Windows clipboard in Python?
  24. Tkinter KeyPress and KeyRelease events
  25. Pandas bar plot with binned range
  26. Python- Writing text to a file?
  27. AttributeError while adding colorbar in matplotlib
  28. Changing certain values in multiple columns of a pandas DataFrame at once
  29. How can I share a class between processes?
  30. How to make a large file accessible to external APIs?

Leave a Comment