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-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 ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-configuration-dsn-windows-5-2.html
From the "Create New Data Source" dialog, select the MySQL ODBC 5.x ANSI or Unicode Driver, then click Finish to open its connection parameters dialog. Figure 5.2 Create New Data Source Dialog: Choosing a MySQL ODBC Driver You now need to configure ... The ODBC Data Source Administrator on Windows lets you create DSNs, check driver installation, and configure ODBC functions such as tracing (used for debugging) and connection ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-installation-binary-macos.html
macOS is based on the FreeBSD operating system, and you can normally use the MySQL network port for connecting to MySQL servers on other hosts. Installing the Connector/ODBC driver lets you connect to MySQL databases on any platform through the ...