PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/invisible-columns.html
For statements that insert or ignore new rows, or that replace or modify existing rows, based on values in a PRIMARY KEY or UNIQUE index, MySQL treats invisible columns the same as visible columns: Invisible columns participate in key value ...An ...
https://dev.mysql.com/doc/refman/8.0/en/json.html
The UPDATE statement uses any of the three functions JSON_SET(), JSON_REPLACE(), or JSON_REMOVE() to update the column. All changes replace existing array or object values with new ones, and do not add any new elements to the parent object or array.
https://dev.mysql.com/doc/refman/8.0/en/load-data.html
Unless REPLACE is also specified, LOCAL has the same effect as the IGNORE modifier on the interpretation of input file contents and error handling; see Duplicate-Key and Error Handling, and Column Value Assignment. If none of REPLACE, IGNORE, or ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-conflict-resolution.html
Conflict resolution algorithms requiring the old values, such as NDB$MAX() and NDB$OLD(), do not work correctly with these binlog_type values. Because the conflict detection algorithms employed by NDB$EPOCH() and NDB$EPOCH_TRANS() are asymmetric, ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-replica.html
If it does, the relative part of the path is replaced with the absolute path set using the relay_log system variable. If replica_compressed_protocol is enabled, it takes precedence over any SOURCE_COMPRESSION_ALGORITHMS option specified for the ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations.html
ALGORITHM=INSTANT on a partitioned table, it is no longer possible to exchange partitions with this table. Be aware that, if your application uses REPLACE statements and you do this, the results of these statements can be drastically altered. See ...
https://dev.mysql.com/doc/refman/8.0/en/range-optimization.html
The correct way to remove them is to replace them with TRUE, so that we do not miss any matching rows when doing the range scan. The range condition extraction algorithm can handle nested AND/OR constructs of arbitrary depth, and its output does not ... The range access method uses a single index to retrieve a subset of table rows that are contained within one or several index value ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log-transaction-compression.html
When binary log transaction compression is enabled, transaction payloads are compressed using the zstd algorithm, and then written to the server's binary log file as a single event (a Transaction_payload_event). You can also use the ... Beginning ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-foreign-keys.html
(Bug #89511, Bug #27484882) InnoDB performs cascading operations using a depth-first search algorithm on the records of the index that corresponds to the foreign key constraint. MySQL supports foreign keys, which permit cross-referencing related ...
https://dev.mysql.com/doc/refman/8.0/en/drop-index.html
algorithm_option: ALGORITHM [=] {DEFAULT | INPLACE | COPY} lock_option: LOCK [=] {DEFAULT | NONE | SHARED | EXCLUSIVE} DROP INDEX drops the index named index_name from the table tbl_name. ALGORITHM and LOCK clauses may be given to influence the ...