https://dev.mysql.com/partitioning-selection.html
Explicit selection of partitions and subpartitions for rows matching a given WHERE condition is supported. Partition selection is similar to partition pruning, in that only specific partitions are checked for matches, but differs in two key ...
https://dev.mysql.com/json-table-functions.html
The optional on_error clause determines what JSON_TABLE() does when saving an object or array: NULL ON ERROR: The column is set to NULL; this is the default behavior. This clause is also triggered on a column in a NESTED PATH clause when the latter ... This section contains information about JSON functions that convert JSON data to tabular ...
https://dev.mysql.com/pattern-matching.html
MySQL provides standard SQL pattern matching as well as a form of pattern matching based on extended regular expressions similar to those used by Unix utilities such as vi, grep, and sed. SQL pattern matching enables you to use _ to match any ...
https://dev.mysql.com/sql-mode.html
If this mode is not enabled, division by zero inserts NULL and produces no warning. If this mode is enabled, division by zero inserts NULL and produces a warning. For INSERT IGNORE and UPDATE IGNORE, division by zero inserts NULL and produces a ...
https://dev.mysql.com/innodb-online-ddl-operations.html
Adding a SPATIAL index CREATE TABLE geom (g GEOMETRY NOT NULL); ALTER TABLE geom ADD SPATIAL INDEX(g), ALGORITHM=INPLACE, LOCK=SHARED; Adding the first FULLTEXT index rebuilds the table if there is no user-defined FTS_DOC_ID column. Online support ...
https://dev.mysql.com/mysql-cluster-replication-schema.html
Replication in NDB Cluster makes use of a number of dedicated tables in the mysql database on each MySQL Server instance acting as an SQL node in both the cluster being replicated and the replication slave (whether the slave is a single server or a ...
https://dev.mysql.com/partitioning-pruning.html
Important Invalid DATE and DATETIME values referenced in the WHERE condition of a statement against a partitioned table are treated as NULL. The optimization known as partition pruning is based on a relatively simple concept which can be described ...
https://dev.mysql.com/sys-statement-performance-analyzer.html
If in_table is NULL and no snapshot exists, a new snapshot is created. Creates a report of the statements running on the server. The views are calculated based on the overall and/or delta activity. This procedure disables binary logging during its ...
https://dev.mysql.com/alter-table.html
Running ALTER TABLE tbl_name ENGINE=INNODB on an existing InnoDB table performs a “null” ALTER TABLE operation, which can be used to defragment an InnoDB table, as described in Section 15.11.4, “Defragmenting a Table”. As of MySQL 8.0.14, ...
https://dev.mysql.com/data-masking-reference.html
Return value: The masked string, or NULL if either margin is negative. Return value: The masked string, or NULL if either margin is negative. Return value: The masked Social Security number as a string, or NULL if the argument is not the correct ...
