PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-metrics-table.html
Because no DML operations have been performed, the counter values are zero or NULL. row *************************** NAME: dml_inserts SUBSYSTEM: dml COUNT: 0 MAX_COUNT: 0 MIN_COUNT: NULL AVG_COUNT: 0 COUNT_RESET: 0 MAX_COUNT_RESET: 0 ... The ...
https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html
Alternatively, start the mysql client with --skip-binary-as-hex to cause all binary values to be displayed as text.) If either function argument is NULL, the function returns NULL. If AES_DECRYPT() detects invalid data or incorrect padding, it ...If ...
https://dev.mysql.com/doc/refman/8.0/en/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/doc/refman/8.0/en/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/doc/refman/8.0/en/mysql-cluster-replication-conflict-resolution.html
(An example that uses NDB$OLD() with an exceptions table is shown later in this section.) Additional columns may optionally be defined following the copied primary key columns, but not before any of them; any such extra columns cannot be NOT NULL.
https://dev.mysql.com/doc/refman/8.0/en/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 you ... MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data ...
https://dev.mysql.com/doc/refman/8.0/en/ansi-diff-foreign-keys.html
If ON UPDATE CASCADE or ON UPDATE SET NULL recurses to update the same table it has previously updated during the same cascade, it acts like RESTRICT. This means that you cannot use self-referential ON UPDATE CASCADE or ON UPDATE SET NULL operations. A self-referential ON DELETE SET NULL, on the other hand, is possible, as is a self-referential ON DELETE ...For example, if you define a RESTRICT type constraint, ...
https://dev.mysql.com/doc/refman/8.0/en/logical-operators.html
Table 14.5 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/doc/refman/8.0/en/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 ...
https://dev.mysql.com/doc/refman/8.0/en/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 11.1.1, “String Literals”. If the FIELDS ESCAPED BY character is empty, no characters are ...