Search Results
https://dev.mysql.com/doc/refman/8.4/en/enum.html
An ENUM is a string object with a value chosen from a list of permitted values that are enumerated explicitly in the column specification at table creation time. The ENUM type has these advantages: Compact data storage in situations where a column ...See Section 13.3.1, “String Data Type Syntax” for ENUM type syntax and length ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-options-variables.html
--ndb-default-column-format=[FIXED|DYNAMIC] Command-Line Format --ndb-default-column-format={FIXED|DYNAMIC} System Variable ndb_default_column_format Scope Global Dynamic Yes SET_VAR Hint Applies No Type Enumeration Default Value FIXED Valid Values ... This section provides information about MySQL server options, server and status variables that are specific to NDB ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-binary-log.html
In MySQL row-based replication, each row change event contains two images, a “before” image whose columns are matched against when searching for the row to be updated, and an “after” image containing the changes. Normally, MySQL logs full ...
https://dev.mysql.com/doc/internals/en/replication-correct.html
For purposes of defining "correct replication", the tables are considered equal if they are equal on the common columns. (rpl-missing-slave-columns) binlog_format=ROW and the master has extra columns after the columns of the slave, as long as the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-parallel-load-syntax.html
This adds an include list to exactly specify the tables and columns to load for a set of queries. It is no longer necessary to include a complete schema, and exclude unnecessary tables and columns. It follows all the options and the load ... MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/insert-on-duplicate.html
If column b is also unique, the INSERT is equivalent to this UPDATE statement instead: UPDATE t1 SET c=c+1 WHERE a=1 OR b=2 LIMIT 1; If a=1 OR b=2 matches several rows, only one row is updated. The ON DUPLICATE KEY UPDATE clause can contain multiple ... If you specify an ON DUPLICATE KEY UPDATE clause and a row to be inserted would cause a duplicate value in a UNIQUE index or PRIMARY KEY, an UPDATE of the old row ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-command-options.html
This option is on by default, which enables database, table, and column name completion. (This applies to statements terminated by ; or \G.) --batch, -B Command-Line Format --batch Print results using tab as the column separator, with each row on a ... mysql supports the following options, which can be specified on the command line or in the [mysql] and [client] groups of an option ...
https://dev.mysql.com/doc/refman/8.4/en/order-by-optimization.html
The index may also be used even if the ORDER BY does not match the index exactly, as long as all unused portions of the index and all extra ORDER BY columns are constants in the WHERE clause. If the index does not contain all columns accessed by the ... This section describes when MySQL can use an index to satisfy an ORDER BY clause, the filesort operation used when an index cannot be used, and execution plan information available from the optimizer about ORDER ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-0.html
(Bug #36337893) Partitioning: Silent omission of columns with index prefixes as part of a table's partitioning key was deprecated in MySQL 8.0.21, and generated a warning. In this release, the use of any such columns in the proposed partitioning key ...(Bug #36301441) Audit log filtering by type, using error as the type, did not work ...
https://dev.mysql.com/doc/ndbapi/en/overview-ndbinterpretedcode-using.html
Method Buffer (words) Request message (words) load_const_null() 1 1 load_const_u16() 1 1 load_const_u32() 2 2 load_const_u64() 3 3 NdbInterpretedCode Methods for Copying Values Between Registers and Table Columns NdbInterpretedCode provides two ...