Search Results
https://dev.mysql.com/doc/connectors/en/connector-odbc-general-information.html
ODBC (Open Database Connectivity) provides a way for client programs to access a wide range of databases or data sources. ODBC is a standardized API that enables connections to SQL database servers. It was developed according to the specifications ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-opentelemetry.html
For applications on Linux systems that use OpenTelemetry (OTel) instrumentation, the connector adds query and connection spans to the trace generated by application code and forwards the current OpenTelemetry context to the server. Note OTel ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-usagenotes-functionality.html
This section provides help with common queries and areas of functionality in MySQL and how to use them with Connector/ODBC.
https://dev.mysql.com/doc/connectors/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/connectors/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/connectors/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/connectors/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/connectors/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 6.9.5, “cursor.MySQLCursor ...
https://dev.mysql.com/doc/connectors/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 ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-get-rows.html
Syntax: cnx.get_rows(count=None) This method retrieves all or remaining rows of a query result set, returning a tuple containing the rows as sequences and the EOF packet information. The count argument can be used to obtain a given number of rows.