MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 11 to 18 of 18 total results

« Previous
1
2
Next »

https://dev.mysql.com/doc/refman/8.0/en/alter-table.html

ALTER TABLE tbl_name [alter_option [, alter_option] ...] [partition_options] alter_option: { table_options | ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name] | ADD [COLUMN] (col_name column_definition,...) | ADD {INDEX | KEY} ...

26.1 Overview of Partitioning in MySQL

https://dev.mysql.com/doc/refman/8.0/en/partitioning-overview.html

In addition, MAX_ROWS and MIN_ROWS can be used to determine the maximum and minimum numbers of rows, respectively, that can be stored in each partition. The MAX_ROWS option can also be useful for creating NDB Cluster tables with extra partitions, ...

25.6.16.23 The ndbinfo dictionary_tables Table

https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-dictionary-tables.html

dictionary_tables contains the columns listed here: table_id The table' unique ID database_name Name of the database containing the table table_name Name of the table status The table status; one of New, Changed, Retrieved, Invalid, or Altered.

2.3 Installing MySQL on Microsoft Windows

https://dev.mysql.com/doc/refman/8.0/en/windows-installation.html

Do not forget to use MAX_ROWS and AVG_ROW_LENGTH when you create tables. Important MySQL 8.0 Server requires the Microsoft Visual C++ 2019 Redistributable Package to run on Windows platforms. Users should make sure the package has been installed on ...

25.6.12 Online Operations with ALTER TABLE in NDB Cluster

https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-online-operations.html

Setting MAX_ROWS to 0 using an online ALTER TABLE statement is disallowed. MySQL NDB Cluster 8.0 supports online table schema changes using ALTER TABLE ... NDB Cluster handles COPY and INPLACE as described in the next few paragraphs. For ...

18.7 The MERGE Storage Engine

https://dev.mysql.com/doc/refman/8.0/en/merge-storage-engine.html

The MERGE storage engine, also known as the MRG_MyISAM engine, is a collection of identical MyISAM tables that can be used as one. “Identical” means that all tables have identical column data types and index information. You cannot merge MyISAM ...

11.3 Keywords and Reserved Words

https://dev.mysql.com/doc/refman/8.0/en/keywords.html

Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Some keywords which are otherwise ...

15.1.20.12 Setting NDB Comment Options

https://dev.mysql.com/doc/refman/8.0/en/create-table-ndb-comment-options.html

Using MAX_ROWS to force the number of partitions is deprecated but continues to be supported for backward compatibility; it is subject to removal in a future release of MySQL NDB Cluster. NDB_COLUMN Options NDB_TABLE Options It is possible to set a ...