Search Results
https://dev.mysql.com/doc/refman/8.4/en/create-table-gipks.html
To make the generated invisible primary key on auto_1 visible, execute this ALTER TABLE statement: mysql> ALTER TABLE auto_1 ALTER COLUMN my_row_id SET VISIBLE; Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> SHOW ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-auto-increment-handling.html
InnoDB provides a configurable locking mechanism that can significantly improve scalability and performance of SQL statements that add rows to tables with AUTO_INCREMENT columns. To use the AUTO_INCREMENT mechanism with an InnoDB table, an ...The ...
https://dev.mysql.com/doc/heatwave/en/heatwave-errors.html
If the issue persists, reload the table and retry the query with use_secondary_engine session variable set to FORCED. Error number: 1010; Symbol: HW_ER_SUBQUERY_TRANSFORM Message: The subquery, [%s], cannot be transformed into a semi-join, anti-join ... The following list contains all current MySQL HeatWave errors in numerical ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-usage-differences.html
ALTER TABLE tbl_name ENGINE=engine_name fails because it updates the storage engine designation, which is stored in the data dictionary. Use of a data dictionary-enabled MySQL server entails some operational differences compared to a server that ...
https://dev.mysql.com/doc/refman/8.4/en/rebuilding-tables.html
Methods for rebuilding a table include: Dump and Reload Method ALTER TABLE Method REPAIR TABLE Method Dump and Reload Method If you are rebuilding tables because a different version of MySQL cannot handle them after a binary (in-place) upgrade or ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-page-compression.html
Page compression is enabled by specifying the COMPRESSION attribute with CREATE TABLE or ALTER TABLE. For example: CREATE TABLE t1 (c1 INT) COMPRESSION="zlib"; You can also enable page compression in an ALTER TABLE statement. ALTER TABLE t1 ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-disk-data-objects.html
For example, if an NDB Cluster has 4 data nodes, then the ALTER TABLESPACE statement just shown creates 4 data files, 1 each in the data directory of each of the 4 data nodes; each of these files is named data_2.dat, and each file is 48 MB in size.
https://dev.mysql.com/doc/refman/8.4/en/alter-database.html
TEMPORARY tables; it is possible to create, alter, drop, and write to TEMPORARY tables in a read-only database. alter_option: { [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_name | [DEFAULT] ENCRYPTION [=] {'Y' | 'N'} | ...If the database name is omitted, the statement applies to the default ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-maintenance.html
You can use a number of extensions to ALTER TABLE for performing operations of this type on one or more partitions directly, as described in the following list: Rebuilding partitions. If you have deleted a large number of rows from a partition or if ... A number of table and partition maintenance tasks can be carried out on partitioned tables using SQL statements intended for such ...
https://dev.mysql.com/doc/ndbapi/en/ndb-column.html
Beginning with NDB 8.0.30, you can change the inline size of a blob column in the mysql client by setting BLOB_INLINE_SIZE in a column comment as part of CREATE TABLE or ALTER TABLE. You can increase the blob part size of a blob column to the ...The ...