Search Results
https://dev.mysql.com/doc/workbench/en/wb-table-editor-indexes-tab.html
To drop an index, right-click the index name and then click the Delete Selected menu item. The Indexes subtab contains all of the index information for your table. The following figure shows an example of the layout with the PRIMARY index of the ...
https://dev.mysql.com/doc/workbench/en/wb-table-editor-triggers-tab.html
The Triggers subtab opens a workspace that enables you to create new triggers or edit existing triggers. All triggers are organized within a tree structure by section, such as BEFORE INSERT and AFTER INSERT. To add a new trigger, click the [+] icon ...
https://dev.mysql.com/doc/workbench/en/wb-using-text-object-tool.html
However, since a text object is not a database object, there is no confirmation dialog box when you delete a text object. To add text objects to an EER Diagram, use the Text Object tool on the vertical toolbar. Make sure that the EER Diagram tab is ...
https://dev.mysql.com/doc/connectors/en/connector-j-client-authentication.html
After the step, you can delete the PKCS #12 archive (client-keystore.p12 in the example). The server may want to authenticate a client and require the client to provide an SSL certificate to it, which it verifies against its known certificate ...
https://dev.mysql.com/doc/connectors/en/connector-net-entityframework60.html
Code First Features Following are new Code First features supported by Connector/NET: Code First Mapping to Insert/Update/Delete Stored Procedures supported: modelBuilder.Entity<EntityType>().MapToStoredProcedures(); Idempotent migrations scripts ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-mysqlcommand.html
Class methods enable you to perform the following database operations: Query a database Insert, update, and delete data Return a single value Command-based database operations can run within a transaction, if needed. The MySqlCommand class ...
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-asp-provider-profile.html
The Profile Provider also enables profile data to be managed effectively, for example it enables profiles that have not been accessed since a specific date to be deleted. This tutorial shows you how to use the MySQL Profile Provider to store user ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-configuration-connection-parameters.html
On Unix and macOS, use the parameter name and value as the keyword/value pair in the DSN configuration. Alternatively, you can set these parameters within the InConnectionString argument in the SQLDriverConnect() call. Table 5.1 Connector/ODBC DSN ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-examples-overview.html
For Delete / Update / Insert the results might include the number of rows affected. Interacting with a MySQL server from an applications using the Connector/ODBC typically involves the following operations: Configure the Connector/ODBC DSN. This ...
https://dev.mysql.com/doc/connectors/en/connector-python-coding.html
You use the SQL INSERT, UPDATE, and DELETE statements to update different items concurrently, writing only the changed values to disk. The following guidelines cover aspects of developing MySQL applications that might not be immediately obvious to ...