Search Results
https://dev.mysql.com/doc/connectors/en/connector-odbc-general-information.html
ODBC (Open Database Connectivity) provides a way for client programs to access a wide range of databases or data sources. ODBC is a standardized API that enables connections to SQL database servers. Open Database Connectivity (ODBC) is a widely ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-ping.html
Syntax: cnx.ping(reconnect=False, attempts=1, delay=0) Check whether the connection to the MySQL server is still available. When reconnect is set to True, one or more attempts are made to try to reconnect to the MySQL server, and these options are ...Use the delay argument (seconds) if you want to wait between each ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-set-charset-collation.html
Syntax: cnx.set_charset_collation(charset=None, collation=None) This method sets the character set and collation to be used for the current connection. In the following example, we set the character set to latin1 and the collation to ...The charset ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursor-constructor.html
If omitted, the cursor is created but its execute() method raises an exception.
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursorprepared.html
In Connector/Python, there are two ways to create a cursor that enables execution of prepared statements using the binary protocol. In both cases, the cursor() method of the connection object returns a MySQLCursorPrepared object: The simpler syntax ...In MySQL, there are two ways to execute a prepared statement: Use the PREPARE and EXECUTE ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-pooledmysqlconnection-constructor.html
Syntax: PooledMySQLConnection(cnxpool, cnx) This constructor takes connection pool and connection arguments and returns a pooled connection.
https://dev.mysql.com/doc/connector-net/en/connector-net-entityframework-core.html
MySQL Connector/NET integrates support for Entity Framework Core (EF Core). The requirements and configuration of EF Core depend on the version of Connector/NET installed and the features that you require. The following example shows how to set the ...Configuration with MySQL To use Entity Framework Core with a MySQL database, do the following: Install the NuGet ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-blob-reading.html
After a file is loaded into the file table, we can use the MySqlDataReader class to retrieve it. The GetBytes method of the MySqlDataReader is used to load the BLOB into a byte array, which is then written to disk using a FileStream object. The ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-programming-net-vb.html
The following sample creates a table my_vb_net and demonstrates the use in VB.
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-programming-vb-ado.html
The following ADO (ActiveX Data Objects) example creates a table my_ado and demonstrates the use of rs.addNew, rs.delete, and rs.update. rs.Open "SELECT * FROM my_ado" rs!Name = "update" rs!txt = "updated-second-time" rs.Update rs.Close 'rs delete ...