https://dev.mysql.com/server-error-reference.html
Error number: 1121; Symbol: ER_NULL_COLUMN_IN_INDEX; SQLSTATE: 42000 Message: Table handler doesn't support NULL in given index. Error number: 1770; Symbol: ER_GTID_NEXT_CANT_BE_AUTOMATIC_IF_GTID_NEXT_LIST_IS_NON_NULL; SQLSTATE: HY000 Message: The ... The MySQL server writes some error messages to its error log, and sends others to client ...
https://dev.mysql.com/window-functions-frames.html
For RANGE, the bound is the rows with values equal to the current row value minus expr; if the current row value is NULL, the bound is the peers of the row. For RANGE, the bound is the rows with values equal to the current row value plus expr; if ...
https://dev.mysql.com/create-table-foreign-keys.html
SET NULL: Delete or update the row from the parent table, and set the foreign key column or columns in the child table to NULL. Both ON DELETE SET NULL and ON UPDATE SET NULL clauses are supported. If you specify a SET NULL action, make sure that ...
https://dev.mysql.com/logical-operators.html
Table 12.4 Logical Operators Name Description AND, && Logical AND NOT, ! Negates value OR, || Logical OR XOR Logical XOR In SQL, all logical operators evaluate to TRUE, FALSE, or NULL (UNKNOWN). In MySQL, these are implemented as 1 (TRUE), 0 ...
https://dev.mysql.com/mysql-cluster-replication-conflict-resolution.html
This function must be specified as one of those shown in the following list: NDB$OLD(column_name) NDB$MAX(column_name) NDB$MAX_DELETE_WIN() NDB$EPOCH() and NDB$EPOCH_TRANS() NDB$EPOCH_TRANS() NDB$EPOCH2() NDB$EPOCH2_TRANS() NULL: Indicates that ...
https://dev.mysql.com/outer-join-simplification.html
Instead, MySQL converts the query to a query with no outer join operation if the WHERE condition is null-rejected. (That is, it converts the outer join to an inner join.) A condition is said to be null-rejected for an outer join operation if it ...
https://dev.mysql.com/index-statistics.html
For a join based on the <=> comparison operator, NULL is not treated differently from any other value: NULL <=> NULL, just as N <=> N for any other N. However, for a join based on the = operator, NULL is different from non-NULL values: expr1 = expr2 ... Storage engines collect statistics about tables for use by the ...
https://dev.mysql.com/json-modification-functions.html
All members of the second object which do not have a corresponding key in the first object, and whose value is not the JSON null literal. All members with a key that exists in both the first and the second object, and whose value in the second ...
https://dev.mysql.com/load-data.html
The rules for NULL handling are described later in this section. \Z ASCII 26 (Control+Z) \N NULL For more information about \-escape syntax, see Section 9.1.1, “String Literals”. If the FIELDS ESCAPED BY character is empty, no characters are ...
https://dev.mysql.com/window-function-descriptions.html
Some window functions permit a null_treatment clause that specifies how to handle NULL values when calculating results. It is part of the SQL standard, but the MySQL implementation permits only RESPECT NULLS (which is also the default). This ...
