MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 41 to 50 of 139 total results

https://dev.mysql.com/doc/refman/8.0/en/range-optimization.html

The range access method uses a single index to retrieve a subset of table rows that are contained within one or several index value intervals. The following sections describe conditions under which the optimizer uses range access. Additionally, for ...

10.2.2.1 Optimizing IN and EXISTS Subquery Predicates with Semijoin Transformations

https://dev.mysql.com/doc/refman/8.0/en/semijoins.html

NOT IN (SELECT ...)) IS NOT FALSE and its equivalent (... In MySQL 8.0.17 and later, the subquery can also be the argument to an expression modified by NOT, IS [NOT] TRUE, or IS [NOT] FALSE. A semijoin is a preparation-time transformation that ...

8.4.5.9 Disabling Audit Logging

https://dev.mysql.com/doc/refman/8.0/en/audit-log-disabling.html

The plugin is re-enabled when audit_log_disable is set back to false, which is the default setting. The audit_log_disable variable, introduced in MySQL 8.0.28, permits disabling audit logging for all connecting and connected sessions. The ...

2.2 Installing MySQL on Unix/Linux Using Generic Binaries

https://dev.mysql.com/doc/refman/8.0/en/binary-installation.html

$> groupadd mysql $> useradd -r -g mysql -s /bin/false mysql Note Because the user is required only for ownership purposes, not login purposes, the useradd command uses the -r and -s /bin/false options to create a user that does not have login ...

11.1.6 Boolean Literals

https://dev.mysql.com/doc/refman/8.0/en/boolean-literals.html

The constants TRUE and FALSE evaluate to 1 and 0, respectively. mysql> SELECT TRUE, true, FALSE, false; -> 1, 1, 0, 0 .

6.4.1 comp_err — Compile MySQL Error Message File

https://dev.mysql.com/doc/refman/8.0/en/comp-err.html

--help, -? Command-Line Format --help Type Boolean Default Value false Display a help message and exit. --debug-info, -T Command-Line Format --debug-info Type Boolean Default Value false Print some debugging information when the program exits.

6.2.5 Connecting to the Server Using URI-Like Strings or Key-Value Pairs

https://dev.mysql.com/doc/refman/8.0/en/connecting-using-uri-or-key-value-pairs.html

Up to MySQL 8.0.19, the values for this option are true (or 1) which enables compression, and the default false (or 0) which disables compression. For example: mysqlx://user@host?connection-attributes mysqlx://user@host?connection-attributes=true ...

15.1.20.6 CHECK Constraints

https://dev.mysql.com/doc/refman/8.0/en/create-table-check-constraints.html

If the condition evaluates to FALSE, it fails and a constraint violation occurs. CHECK constraints are evaluated for INSERT, UPDATE, REPLACE, LOAD DATA, and LOAD XML statements and an error occurs if a constraint evaluates to FALSE. IGNORE ... Prior ...

15.6.7.2 DECLARE ... HANDLER Statement

https://dev.mysql.com/doc/refman/8.0/en/declare-handler.html

statement handler_action: { CONTINUE | EXIT | UNDO } condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value | condition_name | SQLWARNING | NOT FOUND | SQLEXCEPTION } The DECLARE ... HANDLER statement specifies a handler that deals ...

14.17.1 JSON Function Reference

https://dev.mysql.com/doc/refman/8.0/en/json-function-reference.html

Table 14.22 JSON Functions Name Description Introduced Deprecated -> Return value from JSON column after evaluating path; equivalent to JSON_EXTRACT(). ->> Return value from JSON column after evaluating path and unquoting the result; equivalent to ...

Displaying 41 to 50 of 139 total results