Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-features-differing-tables.html
Source and target tables for replication do not have to be identical. A table on the source can have more or fewer columns than the replica's copy of the table. In addition, corresponding table columns on the source and the replica can use ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-syntax.html
Trying either to create a temporary table that uses the NDB storage engine or to alter an existing temporary table to use NDB fails with the error Table storage engine 'ndbcluster' does not support the create option 'TEMPORARY'. CREATE TABLE and ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-desc.html
Three of the table properties that can be set using NDB_TABLE comments embedded in CREATE TABLE and ALTER TABLE statements are also visible in ndb_desc output. You can check that the ALTER TABLE statement has the desired effect using SHOW CREATE ...
https://dev.mysql.com/doc/refman/8.4/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 [, tbl_name2 TO new_tbl_name2] ... You can rename tables locked with a LOCK TABLES statement, ...InnoDB interprets foreign key constraint names that begin with the string “tbl_name_ibfk_” as internally generated ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-loading-data.html
| | | | Warning: Executing the generated script may alter column definitions and secondary engine flags in the schema | | | | Using SQL_MODE: ... After setting up an external table with the files to load into the table, you run HEATWAVE_LOAD command ...Auto Parallel Load then infers the column names from the first row in the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-syntax-warnings.html
SQL Compression Syntax Warnings and Errors for File-Per-Table Tablespaces When innodb_strict_mode is enabled (the default), specifying ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE in CREATE TABLE or ALTER TABLE statements produces the following error if ... This section describes syntax warnings and errors that you may encounter when using the table compression feature with file-per-table tablespaces and general ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-unload.html
This topic contains the following sections: Before You Begin Overview for Unloading Data Automatically Unload Specific Tables Unload All Data Auto Unload Examples What's Next Before You Begin Load structured data using Lakehouse Auto Parallel Load ... You can use MySQL HeatWave Auto Unload to unload data ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-limitations-partitioning-keys-unique-keys.html
These rules also apply to existing nonpartitioned tables that you wish to partition using ALTER TABLE ... The rule governing this relationship can be expressed as follows: All columns used in the partitioning expression for a partitioned table must ... This section discusses the relationship of partitioning keys with primary keys and unique ...
https://dev.mysql.com/doc/refman/8.4/en/sql-mode.html
NO_ENGINE_SUBSTITUTION Control automatic substitution of the default storage engine when a statement such as CREATE TABLE or ALTER TABLE specifies a storage engine that is disabled or not compiled in. For ALTER TABLE, a warning occurs and the table ...When working with InnoDB tables, consider also the innodb_strict_mode system ... The MySQL server can operate in different SQL modes, and can apply these modes ...
https://dev.mysql.com/doc/workbench/en/wb-sql-editor-navigator.html
Alter Table: Displays the table editor loaded with the details of the table. These items can be explored to show tables, views, and routines within the schema as the following figure shows. Right-clicking on a schema provides similar options to the ... The Navigator area of the sidebar contains options to manage the active MySQL ...