Search Results
https://dev.mysql.com/doc/connectors/en/connector-python-example-cursor-select.html
We then create a new cursor, by default a MySQLCursor object, using the connection's cursor() method. Connector/Python converts hire_start and hire_end from Python types to a data type that MySQL understands and adds the required quotes. After ...
https://dev.mysql.com/doc/connectors/en/connector-python-example-cursor-transaction.html
When you use a transactional storage engine such as InnoDB (the default in MySQL 5.5 and higher), you must commit the data after a sequence of INSERT, DELETE, and UPDATE statements. We then create a new cursor, by default a MySQLCursor object, using ... Inserting or updating data is also done using the handler structure known as a ...
https://dev.mysql.com/doc/connectors/en/connector-python-verification.html
The C Extension is installed as _mysql_connector.so and _mysqlxpb.so in the site-packages directory, not in the mysql/connector and mysqlx directories for the classic interface and X DevAPI, respectively. Verify the C-extension To verify the ...
https://dev.mysql.com/doc/connector-net/en/connector-net-async-methods.html
Requirements Async-Await support requires .NET Framework 4.5 or later TAP support requires .NET Framework 4.0 or later MySQL Connector/NET 6.9 or later Methods The following methods can be used with either TAP or Async-Await. private async void ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-blob-writing.html
After assigning the byte array as a parameter of the MySqlCommand object, the ExecuteNonQuery method is called and the BLOB is inserted into the file table. To write a file to a database, we need to convert the file to a byte array, then use the ...
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. The following code shows a simple example of using the MySqlBulkLoader class. Further information on MySqlBulkLoader can be found in the reference ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-mysqlcommand.html
The MySqlCommand class represents a SQL statement to execute against a MySQL database. For a short tutorial demonstrating how and when to use the ExecuteReader, ExecuteNonQuery, and ExecuteScalar methods, see Section 6.1.2, “The MySqlCommand ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-prepared.html
To prepare a statement, use the following sequence of steps: Create a MySqlCommand object and set the CommandText property to your query. Prepared statements can provide significant performance improvements on queries that are executed more than ...
https://dev.mysql.com/doc/connector-net/en/connector-net-support-bug-report.html
If you encounter difficulties or problems with MySQL Connector/NET, contact the Connector/NET community, as explained in Section 9.1, “Connector/NET Community Support”. First try to execute the same SQL statements and commands from the mysql ...
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-data-adapter.html
Previously, when using MySqlDataReader, the connection to the database was continually maintained unless explicitly closed. This decoupled mode of working with data is supported by MySQL Connector/NET. The Data Adapter is created by instantiating ...It is also possible to work in a manner where a connection is only established when ...