Search Results
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursor-fetchall.html
Syntax: rows = cursor.fetchall() The method fetches all (or all remaining) rows of a query result set and returns a list of tuples. If no more rows are available, it returns an empty list.
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursor-fetchmany.html
Syntax: rows = cursor.fetchmany(size=1) This method fetches the next set of rows of a query result and returns a list of tuples. If no more rows are available, it returns an empty list. The number of rows returned can be specified using the size ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-telemetry.html
OpenTelementry (OTel) standardizes instrumentation, generation, collecting and exporting telemetry data to be consumed by an Observability backend. Starting in Connector/NET 8.1.0, support for OTel is encapsulated in the MySQL.Data.OpenTelemetry ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-tracing-mysql-custom-listeners.html
This enables groups of queries on the same connection to be identified. To build custom listeners that work with the MySQL Connector/NET Trace Source, it is necessary to understand the key methods used, and the event data formats used. The main ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming.html
MySQL Connector/NET comprises several classes that are used to connect to the database, execute queries and statements, and manage query results. The following are the major classes of Connector/NET: MySqlConnection: Represents an open connection ...
https://dev.mysql.com/doc/connector-net/en/connector-net-ref-common-dnsclient.html
A four bit field that specifies kind of query in this message. This value is set by the originator of a query and copied into the response.
https://dev.mysql.com/doc/connector-net/en/connector-net-ref-mysqlclient.html
Classes Class Description AuthenticationPluginConfigurationElement Retrieves the authentication plugin configuration from the configuration file. BaseCommandInterceptor Provides a means of enhancing or replacing SQL commands through the connection ...
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-stored-procedures.html
This technique avoids duplicating database code, saving time and effort when you make updates due to schema changes, tune the performance of queries, or add new database operations for logging, security, and so on. Putting database-intensive ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-apptips-borland-builder.html
When you start a query, you can use the Active property or the Open method. The Active property starts by automatically issuing a SELECT * FROM ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-functionality-last-insert-id.html
Obtaining the value of column that uses AUTO_INCREMENT after an INSERT statement can be achieved in a number of different ways. To obtain the value immediately after an INSERT, use a SELECT query with the LAST_INSERT_ID() function. For example, ...