Search Results
https://dev.mysql.com/doc/refman/8.4/en/upgrade-best-practices.html
MySQL supports upgrading between minor versions (within an LTS series) and to the next major version (across an LTS series). LTS releases have 8+ years of support and are meant for production use. Performing a minor version upgrade is ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-interactive-code-execution.html
The default mode of MySQL Shell provides interactive execution of database operations that you type at the command prompt. These operations can be written in JavaScript, Python or SQL depending on the current Section 5.1, “Active Language”. As ...
https://dev.mysql.com/doc/workbench/en/wb-routine-groups.html
They may be added to an EER diagram by dragging and dropping them from this palette. 9.1.6.2.1 Adding Routine Groups to the Physical Schemata Double-clicking the Add Routine Group icon in the Physical Schemata section of the MySQL Model page adds a ...
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/wbcopytables.html
Trigger Handling Because there is no way to temporarily disable triggers in MySQL and they can affect the copy process, MySQL Workbench will backup and drop all triggers from the target MySQL database before the copy process starts, and then these ... wbcopytables is a command-line utility included in MySQL Workbench that enables you to copy table data from a supported source database server to ...
https://dev.mysql.com/doc/connectors/en/connector-net-ref-efcore.html
MySql.EntityFrameworkCore.Migrations.Operations Namespace Classes Class Description MySQLDropPrimaryKeyAndRecreateForeignKeysOperation A migration operation for dropping a primary key and recreating foreign keys. Namespaces in this section: ...
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-efmodel-ddl.html
For the DDL Generation property select SSDLToMySQL.tt(VS) from the drop-down list. This tutorial demonstrates how to create MySQL DDL from an Entity Framework model. Minimally, you will need Microsoft Visual Studio 2017 and MySQL Connector/NET 6.10 ...
https://dev.mysql.com/doc/connectors/en/connector-python-example-ddl.html
Avoid setting up and dropping tables over and over again, as that is an expensive operation. The exception is temporary tables, which can be created and dropped quickly within an application. All DDL (Data Definition Language) statements are ...
https://dev.mysql.com/doc/connector-net/en/connector-net-ref-efcore.html
MySql.EntityFrameworkCore.Migrations.Operations Namespace Classes Class Description MySQLDropPrimaryKeyAndRecreateForeignKeysOperation A migration operation for dropping a primary key and recreating foreign keys. Namespaces in this section: ...
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-efmodel-ddl.html
For the DDL Generation property select SSDLToMySQL.tt(VS) from the drop-down list. This tutorial demonstrates how to create MySQL DDL from an Entity Framework model. Minimally, you will need Microsoft Visual Studio 2017 and MySQL Connector/NET 6.10 ...