MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 11 to 19 of 19 total results

« Previous
1
2
Next »

10.15.8 The optimizer_trace System Variable

https://dev.mysql.com/doc/refman/8.0/en/optimizer-trace-system-variable.html

The optimizer_trace system variable has these on/off switches: enabled: Enables (ON) or disables (OFF) tracing one_line: If set to ON, the trace contains no whitespace, thus conserving space. This renders the trace difficult to read for humans, ...

25.5.22 ndb_redo_log_reader — Check and Print Content of Cluster Redo Log

https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-redo-log-reader.html

Reads a redo log file, checking it for errors, printing its contents in a human-readable format, or both. ndb_redo_log_reader is intended for use primarily by NDB Cluster developers and Support personnel in debugging and diagnosing problems. This ...

14.12 Bit Functions and Operators

https://dev.mysql.com/doc/refman/8.0/en/bit-functions.html

Table 14.17 Bit Functions and Operators Name Description & Bitwise AND >> Right shift << Left shift ^ Bitwise XOR BIT_COUNT() Return the number of bits that are set | Bitwise OR ~ Bitwise inversion The following list describes available bit ...

14.17.7 JSON Schema Validation Functions

https://dev.mysql.com/doc/refman/8.0/en/json-validation-functions.html

Beginning with MySQL 8.0.17, MySQL supports validation of JSON documents against JSON schemas conforming to Draft 4 of the JSON Schema specification. This can be done using either of the functions detailed in this section, both of which take two ...

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 ...

17.18.1 InnoDB Backup

https://dev.mysql.com/doc/refman/8.0/en/innodb-backup.html

The key to safe database management is making regular backups. Hot and cold backups are physical backups that copy actual data files, which can be used directly by the mysqld server for faster restore. Using MySQL Enterprise Backup is the ...

15.6.5.2 IF Statement

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

[ELSE statement_list] END IF The IF statement for stored programs implements a basic conditional construct. Note There is also an IF() function, which differs from the IF statement described here. The IF statement can have THEN, ELSE, and ELSEIF ...

14.9 Full-Text Search Functions

https://dev.mysql.com/doc/refman/8.0/en/fulltext-search.html

MATCH (col1,col2,...) AGAINST (expr [search_modifier]) search_modifier: { IN NATURAL LANGUAGE MODE | IN NATURAL LANGUAGE MODE WITH QUERY EXPANSION | IN BOOLEAN MODE | WITH QUERY EXPANSION } MySQL has support for full-text indexing and searching: A ...

14.1 Built-In Function and Operator Reference

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

The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 14.2, “Loadable Function Reference”. ->> Return value ...