Search Results
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-authentication-user-plugin.html
Advanced users with special security requirements can create their own authentication plugins for MySQL Connector/NET applications. For background and usage information about MySQL authentication plugins, see Authentication Plugins and Writing ...
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-programming-prepared.html
Prepared statements can provide significant performance improvements on queries that are executed more than one time. Prepared execution is faster than direct execution for statements executed more than once, primarily because the query is parsed ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-tracing-mysql.html
This section describes how to set up your application to view MySQL trace information. The first thing you need to do is create a suitable app.config file for your application. The switch level in this case is set to Verbose to display the maximum ...
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-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 ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-programming-vb-rdo.html
The following RDO (Remote Data Objects) example creates a table my_rdo and demonstrates the use of rs.addNew and rs.update. SQL = "select * from my_rdo" Set rs = cn.OpenResultset(SQL, rdOpenStatic, rdConcurRowVer, rdExecDirect) Do Until rs.EOF For ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-apptips-microsoft-access.html
To improve the integration between Microsoft Access and MySQL through Connector/ODBC: For all versions of Access, enable the Connector/ODBC Return matching rows option. Include a TIMESTAMP column in all tables that you want to be able to update.
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 ...