PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/bit-functions.html
The result type depends on whether the arguments are evaluated as binary strings or numbers: Binary-string evaluation occurs when the arguments have a binary string type, and at least one of them is not a hexadecimal literal, bit literal, or NULL ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-files-table.html
The value is NULL for all data files except for predefined system tablespace data files. A NULL value for a predefined system tablespace data file indicates that a file size limit was not defined explicitly. For NDB: For undo log files, this column ... The FILES table provides information about the files in which MySQL tablespace data is ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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/9.7/en/srjs-data-arguments.html
SQL NULL is supported for all the types listed, and is converted to and from JavaScript null as required. Table 27.3 Type Conversion: JavaScript Dates to MySQL JavaScript TypeMySQL DATEMySQL DATETIME, TIMESTAMPMySQL YEARnull or undefined NULL NULL ... Most MySQL data types are supported for MLE stored program input and output arguments, as well as for return data ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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 ...