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-rowcount.html
Syntax: count = cursor.rowcount This read-only property returns the number of rows returned for SELECT statements, or the number of rows affected by DML statements such as INSERT or UPDATE. For nonbuffered cursors, the row count cannot be known ...
https://dev.mysql.com/doc/connectors/en/connector-python-example-connecting.html
The connect() constructor creates a connection to the MySQL server and returns a MySQLConnection object. The following example shows how to connect to the MySQL server: import mysql.connector cnx = mysql.connector.connect(user='scott', ...
https://dev.mysql.com/doc/connectors/en/connector-python-opentelemetry.html
OracleMySQLInstrumentor().instrument() with tracer.start_as_current_span("client_app"): with mysql.connector.connect(**config) as cnx: with cnx.cursor() as cur: cur.execute("SELECT @@version") _ = cur.fetchall() Morphology of the Emitted Traces A ...
https://dev.mysql.com/doc/connector-net/en/connector-net-asp-provider.html
In the web pages that open, you can select the MySQL membership and roles providers by picking a custom provider for each area. MySQL Connector/NET includes a provider model for use with ASP.NET applications. This model enables developers to focus ...
https://dev.mysql.com/doc/connector-net/en/connector-net-authentication.html
In Connector/NET 8.0.33, the OciConfigProfile connection option permits selecting a profile in the configuration file to use for authentication. MySQL Connector/NET implements a variety of authentication plugins that MySQL Server can invoke to ...
https://dev.mysql.com/doc/connector-net/en/connector-net-entityframework60.html
For this option, select nuget.org as the package source, search for mysql.data, and install a stable version of MySql.Data.EntityFramework. MySQL Connector/NET integrates support for Entity Framework 6 (EF6), which now includes support for ...
https://dev.mysql.com/doc/connector-net/en/connector-net-medium-trust-gac.html
myconnString.IncludeSecurityAsserts = true; Define the MySqlConnection to use: MySqlConnection myconn = new MySqlConnection(myconnString.ConnectionString); myconn.Open(); Retrieve some data from your tables: MySqlCommand cmd = new ... If the library ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-bulk-loader.html
MySQL Connector/NET features a bulk loader class that wraps the MySQL statement LOAD DATA INFILE. This gives Connector/NET the ability to load a data file from a local or remote host to the server, or a stream to a database (from Connector/NET ...
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-stored-procedures.html
Putting database-intensive operations into stored procedures lets you define an API for your database application. You can reuse this API across multiple applications and multiple programming languages. This technique avoids duplicating database ...