Documentation Home
MySQL Connector/Python Developer Guide
Related Documentation Download this Manual
PDF (US Ltr) - 0.7Mb
PDF (A4) - 0.7Mb


MySQL Connector/Python Developer Guide  /  Connector/Python C Extension API Reference  /  _mysql_connector.MySQL.convert_to_mysql() Method

11.13 _mysql_connector.MySQL.convert_to_mysql() Method

Syntax:

Press CTRL+C to copy
converted_obj = ccnx.convert_to_mysql(obj))

Converts a Python object to a MySQL value based on the Python type of the object. The converted object is escaped and quoted.

Press CTRL+C to copy
ccnx.query('SELECT CURRENT_USER(), 1 + 3, NOW()') row = ccnx.fetch_row() for col in row: print(ccnx.convert_to_mysql(col)) ccnx.consume_result()

Raises a MySQLInterfaceError exception if the Python object cannot be converted.