Search Results
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-ref-mysqlclient.html
MySqlCommandBuilder Automatically generates single-table commands used to reconcile changes made to a data set with the associated MySQL database. Classes Class Description AuthenticationPluginConfigurationElement Retrieves the authentication ...
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-mysqlscript.html
To run the example programs in this tutorial, set up a simple test database and table using the mysql Command-Line Client or MySQL Workbench. Commands for the mysql Command-Line Client are given here: CREATE DATABASE TestDB; USE TestDB; CREATE TABLE ... This tutorial teaches you how to use the MySqlScript ...
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-sql-command.html
When a connection has been established with the MySQL database, the next step enables you to perform database operations. This task can be achieved through the use of the MySqlCommand object. After it has been created, there are three main methods ...
https://dev.mysql.com/doc/connector-net/en/connector-net-versions.html
The following table shows the versions of ADO.NET, .NET (Core and Framework), and MySQL Server that are supported or required by MySQL Connector/NET. MySQL Connector/NET 9.x series is a continuation of Connector/NET 8.x series, but now named to ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-reference-datatypes.html
The following table illustrates how Connector/ODBC maps the server data types to default SQL and C data types.
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-apptips-microsoft-visualbasic.html
To be able to update a table, you must define a primary key for the table. This means that some queries like SHOW PROCESSLIST do not work properly. The fix is to use OPTION=16384 in the ODBC connect string or to select the Change BIGINT columns to ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-query.html
ccnx.query('DROP TABLE IF EXISTS t') ccnx.query('CREATE TABLE t (i INT NOT NULL AUTO_INCREMENT PRIMARY KEY)') ccnx.query('INSERT INTO t (i) VALUES (NULL),(NULL),(NULL)') ccnx.query('SELECT LAST_INSERT_ID()') row = ccnx.fetch_row() ...raw_as_string ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-errors.html
The following table shows the SQLSTATE classes and the exception Connector/Python raises. The mysql.connector.errors module defines exception classes for errors and warnings raised by MySQL Connector/Python. Most classes defined in this module are ...
https://dev.mysql.com/doc/connector-python/en/connector-python-multi.html
Users must quote these when included in multi statements for other purposes different from declaring an actual statement delimiter; such as names for tables, columns, variables, in comments, and so on. Example: CREATE TABLE `delimiter` (begin INT, ... Connector/Python can execute either a single or multiple statements, this section references multiple statement and associated delimiter ...