Search Results
https://dev.mysql.com/doc/connector-net/en/connector-net-connections-string.html
For example: // classic protocol example "server=10.10.10.10:3306,192.101.10.2:3305,localhost:3306;uid=test;password=xxxx" // X Protocol example mysqlx://test:test@[192.1.10.10:3305,127.0.0.1:3306] An updated failover approach selects the target for ...In each key-value pair, the option name and its corresponding value are joined by an equal ...
https://dev.mysql.com/doc/connector-net/en/connector-net-installation-source.html
Right-click the node and select Build from the context menu to build the solution. If the command is executed from the top directory, such as MySQL.Data, the solution file is selected (new with the .NET Core 3.0 SDK). Building MySQL Connector/NET ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-mysqlcommand.html
In effect, this command performs a SELECT * on the table specified. The following SELECT statement includes the mysql_query_attribute_string() loadable function that is used to retrieve the two attributes decared previously and then prints the ...
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-data-adapter.html
When a MySqlDataAdapter object is created, it is typically given an initial SELECT statement. From this SELECT statement the Command Builder can work out the corresponding INSERT, UPDATE and DELETE statements that would be required to update the ...
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-ssl-pfx.html
In the dialog, click Add and then select the My user account option. Expand the Certificates - Current User tree item and select Personal, Certificates. Instead, Windows includes a certificate store that provides platform-dependent certificates in ...
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-rdo.html
SQL = "select * from my_rdo" Set rs = cn.OpenResultset(SQL, rdOpenStatic, rdConcurRowVer, rdExecDirect) Do Until rs.EOF For Each cl In rs.rdoColumns Debug.Print cl.Value, Next rs.MoveNext Debug.Print Loop Debug.Print "Row count="; rs.RowCount 'close ... The following RDO (Remote Data Objects) example creates a table my_rdo and demonstrates the use of rs.addNew and ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-functionality-last-insert-id.html
To obtain the value immediately after an INSERT, use a SELECT query with the LAST_INSERT_ID() function. For example, using Connector/ODBC you would execute two separate statements, the INSERT statement and the SELECT query to obtain the ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-add-attribute.html
Example query attribute usage: # Each invocation of `add_attribute` method will add a new query attribute: cur.add_attribute("foo", 2) cur.execute("SELECT first_name, last_name FROM clients") # The query above sent attibute "foo" with value 2.