Search Results
https://dev.mysql.com/doc/connectors/en/connector-python-example-cursor-select.html
In the preceding example, we store the SELECT statement in the variable query. The following example shows how to query data using a cursor created using the connection's cursor() method. The task is to select all employees hired in the year 1999 ...
https://dev.mysql.com/doc/connectors/en/connector-python-tutorial-cursorbuffered.html
The following example script gives a long-overdue 15% raise effective tomorrow to all employees who joined in the year 2000 and are still with the company. (A buffered cursor fetches and buffers the rows of a result set after executing a query; see ...
https://dev.mysql.com/doc/connector-net/en/connector-net-connections-string.html
The default database for all statements will be the test database. In each key-value pair, the option name and its corresponding value are joined by an equal sign. For the list of option names to use in the connection string, see Section 4.5, ...
https://dev.mysql.com/doc/connector-net/en/connector-net-interceptors.html
For example, you can examine the SQL statement for logging or debugging purposes, substitute your own result set to implement a caching mechanism, and so on. An interceptor is a software design pattern that provides a transparent way to extend or ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-telemetry.html
If your code does not use instrumentation, then the connector does not forward the current OTel context for each executed statement. OpenTelementry (OTel) standardizes instrumentation, generation, collecting and exporting telemetry data to be ...
https://dev.mysql.com/doc/connector-net/en/connector-net-support-bug-report.html
First try to execute the same SQL statements and commands from the mysql client program. If you encounter difficulties or problems with MySQL Connector/NET, contact the Connector/NET community, as explained in Section 9.1, “Connector/NET ...
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-stored-procedures.html
Before working through this tutorial, familiarize yourself with the CREATE PROCEDURE and CREATE FUNCTION statements that create different kinds of stored routines. Putting database-intensive operations into stored procedures lets you define an API ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-tools-with-wordexcel.html
You use Microsoft Query to build the SQL statement to be executed, selecting the tables, fields, selection criteria and sort order. You can use Microsoft Word and Microsoft Excel to access information from a MySQL database using Connector/ODBC.
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-support-version-history.html
It also includes new features, such as enabling server-side prepared statements by default. This section highlights substantial changes per major Connector/ODBC release series, especially useful when updating legacy code. The connector release ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-apptips-microsoft-access.html
In some cases, Access may generate SQL statements that MySQL cannot understand. To improve the integration between Microsoft Access and MySQL through Connector/ODBC: For all versions of Access, enable the Connector/ODBC Return matching rows option.