Search Results
https://dev.mysql.com/doc/refman/9.7/en/rename-table.html
You must have ALTER and DROP privileges for the original table, and CREATE and INSERT privileges for the new table. RENAME TABLE tbl_name TO new_tbl_name changes internally generated foreign key constraint names and user-defined foreign key ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-recattr-vs-ndbrecord.html
This example illustrates the key differences between the old-style NdbRecAttr API and the newer approach using NdbRecord when performing some common tasks in an NDB API application. The source code can be found can be found in the file ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-add-process.html
If the added nodes are started with start process --initial instead, you are then required to run CREATE NODEGROUP manually via the ndb_mgm client. Using add process to Simplify create cluster Commands Processes added before the cluster is started ...Any hosts referenced in the list must be members of the site to which the cluster ...
https://dev.mysql.com/doc/workbench/en/wb-vertical-toolbar.html
Change to the standard mouse pointer tool and pick up any objects you would like to place on the newly created layer. For more information about text objects, see Section 9.1.9, “Creating Text Objects”. 9.1.2.2.7 The Table Tool Use this tool to ... The vertical toolbar appears on the left sidebar (see the following figure) when an EER diagram tab is ...
https://dev.mysql.com/doc/refman/9.7/en/alter-table-partition-operations.html
This clause always begins with PARTITION BY, and follows the same syntax and other rules as apply to the partition_options clause for CREATE TABLE (for more detailed information, see Section 15.1.24, “CREATE TABLE Statement”), and can also be ...
https://dev.mysql.com/doc/refman/9.7/en/converting-tables-to-innodb.html
Note Partitioned MyISAM tables created in previous versions of MySQL are not compatible with MySQL 9.7. When you convert MyISAM tables that are large, frequently accessed, and hold vital data, investigate and consider the innodb_file_per_table and ... If you have MyISAM tables that you want to convert to InnoDB for better reliability and scalability, review the following guidelines and tips before ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-limitations-partitioning-keys-unique-keys.html
This section discusses the relationship of partitioning keys with primary keys and unique keys. The rule governing this relationship can be expressed as follows: All columns used in the partitioning expression for a partitioned table must be part ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-differing-tables.html
A column's default value is determined by a number of factors, including its type, whether it is defined with a DEFAULT option, whether it is declared as NULL, and the server SQL mode in effect at the time of its creation; for more information, see ... Source and target tables for replication do not have to be ...
https://dev.mysql.com/doc/extending-mysql/9.7/en/adding-loadable-function.html
Loadable Function Calling Sequences for Simple Functions This section describes the different interface functions that you must define to create a simple loadable function. Loadable Function Calling Sequences for Aggregate Functions This section ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-errors.html
On Windows x64 editions, use the ODBC administration tool located at %SystemRoot%\SysWOW64\odbcad32.exe, this will correctly locate the installed Connector/ODBC drivers and enable you to create a Connector/ODBC DSN. A simple example can be found ...