Search Results
https://dev.mysql.com/doc/workbench/en/wb-preferences-sql-editor.html
Figure 3.8 Preferences: SQL Editor: Object Editors Online DDL Default algorithm for ALTER table: [ Default ] Sets the default algorithm when performing ALTER TABLE operations in MySQL Workbench. The setting can also be adjusted for each ALTER TABLE ...For this reason, this facility can be switched off for models containing large numbers of schemas and ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-9-4-1.html
(WL #16513) MySQL HeatWave Lakehouse now supports an optional clause for the ALTER TABLE SECONDARY_LOAD statement, enabling you to control whether MySQL HeatWave Guided Load is used or not. This update introduces additional data preparation ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-general-options.html
The options described in this section can be used for any type of table maintenance operation performed by myisamchk. The sections following this one describe options that pertain only to specific operations, such as table checking or repairing.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-blobs.html
The part and inline sizes of NDB blob columns can be set using CREATE TABLE and ALTER TABLE statements containing NDB table column comments (see NDB_COLUMN Options); this can also be done in NDB API applications (see Column::setPartSize() and ...For ...
https://dev.mysql.com/doc/refman/8.4/en/string-type-syntax.html
In some cases, MySQL may change a string column to a type different from that given in a CREATE TABLE or ALTER TABLE statement. See Section 10.4.7, “Limits on Table Column Count and Row Size”. The string data types are CHAR, VARCHAR, BINARY, ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-creating-channel.html
Advanced options: Tables without primary key: Specify how a replication channel handles the creation and alteration of tables with no primary keys on the source. Raise an error : Raise an error when replicating a CREATE TABLE or ALTER TABLE ...
https://dev.mysql.com/doc/refman/8.4/en/creating-spatial-columns.html
MySQL provides a standard way of creating spatial columns for geometry types, for example, with CREATE TABLE or ALTER TABLE. Use the CREATE TABLE statement to create a table with a spatial column: CREATE TABLE geom (g GEOMETRY); Use the ALTER TABLE ...Spatial columns are supported for MyISAM, InnoDB, NDB, and ARCHIVE ...See also the notes ...
https://dev.mysql.com/doc/refman/8.4/en/example-auto-increment.html
To start with an AUTO_INCREMENT value other than 1, set that value with CREATE TABLE or ALTER TABLE, like this: mysql> ALTER TABLE tbl AUTO_INCREMENT = 100; InnoDB Notes For information about AUTO_INCREMENT usage specific to InnoDB, see Section ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-search-mecab.html
Creating a FULLTEXT Index that uses the MeCab Parser To create a FULLTEXT index that uses the mecab parser, specify WITH PARSER ngram with CREATE TABLE, ALTER TABLE, or CREATE INDEX. For InnoDB tables, minimum token size is defined by the ... The ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-myisam-category.html
Myisam Max Sort File Size The maximum size of the temporary file that MySQL is permitted to use while re-creating a MyISAM index (during REPAIR TABLE, ALTER TABLE, or LOAD DATA INFILE). Myisam Sort Buffer Size The size of the buffer that is ...Table ... Lists the Myisam configuration metrics and provides a brief description of ...