Search Results
https://dev.mysql.com/doc/refman/8.4/en/merge-storage-engine.html
An alternative to a MERGE table is a partitioned table, which stores partitions of a single table in separate files and enables some operations to be performed more efficiently. Use ALTER TABLE tbl_name UNION=(...) to change the list of underlying ... The MERGE storage engine, also known as the MRG_MyISAM engine, is a collection of identical MyISAM tables that can be used as ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-ndb-comment-options.html
NDB_COLUMN Options In NDB Cluster, a column comment in a CREATE TABLE or ALTER TABLE statement can also be used to specify an NDB_COLUMN option. Changing a column's blob part size must be done using a copying ALTER TABLE; this operation cannot be ...
https://dev.mysql.com/doc/refman/8.4/en/grant.html
(Alternatively, if you have the UPDATE privilege for the grant tables in the mysql system schema, you can grant any account any privilege.) When the read_only system variable is enabled, GRANT additionally requires the CONNECTION_ADMIN privilege (or ...ALTER USER may be used to change the nonprivilege characteristics of existing ...[WITH ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-table-syntax-sql.html
The following options apply to CREATE TABLE and ALTER TABLE statements. For ALTER TABLE statements, ADD COLUMN is not supported for external tables. Load the data manually with the ALTER TABLE statement and the option to use Guided Load. As of ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-limitations.html
Partitioning and repartitioning operations (such as ALTER TABLE with PARTITION BY ..., REORGANIZE PARTITION, or REMOVE PARTITIONING) depend on file system operations for their implementation. CREATE TABLE and ALTER TABLE statements that would result ...Tables employing user-defined partitioning do not preserve the SQL mode in effect at the time that they were ...
https://dev.mysql.com/doc/ndbapi/en/ndb-error-codes-single.html
Unable to alter table as backup is in progress 763 MySQL error. Backup failed to insert table list (check configuration) 1347 MySQL error. Backup failed to allocate table memory (check configuration) 1348 MySQL error. Table fragment fixed data ...
https://dev.mysql.com/doc/refman/8.4/en/converting-tables-to-innodb.html
If an ALTER TABLE operation runs out of space, it starts a rollback, and that can take hours if it is disk-bound. Declare the PRIMARY KEY clause in the original CREATE TABLE statement, rather than adding it later through an ALTER TABLE statement.
https://dev.mysql.com/doc/refman/8.4/en/innodb-fulltext-index.html
A full-text index is defined as part of a CREATE TABLE statement or added to an existing table using ALTER TABLE or CREATE INDEX. When incoming documents are tokenized, the individual words (also referred to as “tokens”) are inserted into the ...
https://dev.mysql.com/doc/refman/8.4/en/optimize-table.html
In this case, OPTIMIZE TABLE is just mapped to ALTER TABLE. InnoDB Details For InnoDB tables, OPTIMIZE TABLE is mapped to ALTER TABLE ... OPTIMIZE TABLE rebuilds the table using the table copy method under the following conditions: When the ...
https://dev.mysql.com/doc/refman/8.4/en/delete.html
Given a partitioned table t with a partition named p0, executing the statement DELETE FROM t PARTITION (p0) has the same effect on the table as executing ALTER TABLE t TRUNCATE PARTITION (p0); in both cases, all rows in partition p0 are dropped. To ...