trapping a MySql warning

by

Warnings are just that: warnings. They get reported to (usually) stderr, but nothing else is done. You can’t catch them like exceptions because they aren’t being raised.

You can, however, configure what to do with warnings, and turn them off or turn them into exceptions, using the warnings module. For instance, warnings.filterwarnings('error', category=MySQLdb.Warning) to turn MySQLdb.Warning warnings into exceptions (in which case they would be caught using your try/except) or 'ignore' to not show them at all. You can (and probably should) have more fine-grained filters than just the category.

More Related Contents:

  1. Python read from txt and save into mysql
  2. Lost connection to MySQL server during query
  3. How to install Python MySQLdb module using pip?
  4. Does Python support MySQL prepared statements?
  5. How to convert SQL Query result to PANDAS Data Structure?
  6. How do I get the “id” after INSERT into MySQL database with Python?
  7. Escape string Python for MySQL
  8. How to install MySQLdb (Python data access library to MySQL) on Mac OS X?
  9. pip install mysqlclient returns “fatal error C1083: Cannot open file: ‘mysql.h’: No such file or directory
  10. Cannot return results from stored procedure using Python cursor
  11. How do I get a raw, compiled SQL query from a SQLAlchemy expression?
  12. Enable Python to Connect to MySQL via SSH Tunnelling
  13. Inserting a Python datetime.datetime object into MySQL
  14. MySQL — Joins Between Databases On Different Servers Using Python?
  15. How to retrieve SQL result column value using column name in Python?
  16. Using a Python dict for a SQL INSERT statement
  17. How do I escape % from python mysql query
  18. Bulk insert with SQLAlchemy ORM
  19. RuntimeError: working outside of application context
  20. Insert list into my database using Python [duplicate]
  21. Print the actual query MySQLdb runs?
  22. Can’t install mysql-python (newer versions) in Windows
  23. Using Django database layer outside of Django?
  24. How to move a model between two Django apps (Django 1.7)
  25. How do i cast char to integer while querying in django ORM?
  26. flake8 complains on boolean comparison “==” in filter clause
  27. Remove duplicates in list of object with Python
  28. How do I get time from a datetime.timedelta object?
  29. pip install mysqlclient : Microsoft Visual C++ 14.0 is required
  30. Installing mysql-python on Centos

Leave a Comment