Search Results
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-convert-to-mysql.html
Syntax: converted_obj = ccnx.convert_to_mysql(obj)) Converts a Python object to a MySQL value based on the Python type of the object. ccnx.query('SELECT CURRENT_USER(), 1 + 3, NOW()') row = ccnx.fetch_row() for col in row: ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-fetch-fields.html
Syntax: field_info = ccnx.fetch_fields() Fetches column information for the active result set. Returns a list of tuples, one tuple per column Raises a MySQLInterfaceError exception for any MySQL error returned by the MySQL server.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-fetch-row.html
Syntax: row = ccnx.fetch_row() Fetches the next row from the active result set. The row is returned as a tuple that contains the values converted to Python objects, unless raw was set. ccnx.query('SELECT CURRENT_USER(), 1 + 3, NOW()') row = ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-errors-error.html
This exception is the base class for all other exceptions in the errors module. It can be used to catch all errors in a single except statement. errors.Error is internally used by Connector/Python to raise MySQL client and server errors and should ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-errors-warning.html
Consider using either more strict Server SQL Modes or the raise_on_warnings connection argument to make Connector/Python raise errors when your queries produce warnings. This exception is used for reporting important warnings, however, ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-can-consume-results.html
This property indicates the value of the consume_results connection parameter that controls whether result sets produced by queries are automatically read and discarded.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-cmd-init-db.html
In subsequent queries, this database is the default for table references that include no explicit database qualifier. Syntax: cnx.cmd_init_db(db_name) This method makes specified database the default (current) database.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-cmd-process-info.html
Instead, use the SHOW PROCESSLIST statement or query the tables found in the database INFORMATION_SCHEMA.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-cursor.html
Syntax: cursor = cnx.cursor([arg=value[, arg=value]...]) This method returns a MySQLCursor() object, or a subclass of it depending on the passed arguments. For more information about cursor objects, see Section 10.5, “cursor.MySQLCursor Class”, ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-get-row.html
This method retrieves the next row of a query result set, returning a tuple. The tuple returned by get_row() consists of: The row as a tuple containing byte objects, or None when no more rows are available. EOF packet information as a dictionary ...