MySQL Connector/Python Developer Guide
Syntax:
tuples = cursor.fetchwarnings()
This method returns a list of tuples containing warnings
generated by the previously executed operation. To set whether
to fetch warnings, use the connection's
get_warnings
property.
The following example shows a
SELECT
statement that generates a
warning:
>>> cnx.get_warnings = True >>> cursor.execute("SELECT 'a'+1") >>> cursor.fetchall() [(1.0,)] >>> cursor.fetchwarnings() [(u'Warning', 1292, u"Truncated incorrect DOUBLE value: 'a'")]
When warnings are generated, it is possible to raise errors
instead, using the connection's
raise_on_warnings
property.