Search Results
https://dev.mysql.com/doc/workbench/en/wb-table-editor-foreign-keys-tab.html
Enter a name for the foreign key and select the column or columns that you wish to index by checking the column name in the Column list. The options are: RESTRICT CASCADE SET NULL NO ACTION To drop a foreign key, right-click the row you wish to ...
https://dev.mysql.com/doc/connectors/en/connector-j-logging-slf4j.html
Here is output of the program when the SELECT statement failed: [2021-09-05 12:06:19,624] WARN 0[main] - WARN MySQL - Warning: Select failed! . Besides its default logger com.mysql.cj.log.StandardLogger, which logs to stderr, Connector/J supports ...
https://dev.mysql.com/doc/connectors/en/connector-j-query-attributes.html
Connector/J supports Query Attributes when it has been enabled on the server by installing the query_attributes component (see Prerequisites for Using Query Attributes for details). Attributes are set for a query by using the setAttribute() method ...
https://dev.mysql.com/doc/connectors/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/connectors/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/connectors/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/connectors/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/connectors/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/connectors/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/connectors/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.