PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/fulltext-search-ngram.html
An ngram is a contiguous sequence of n characters from a given sequence of text. The ngram parser tokenizes a sequence of text into a contiguous sequence of n characters. Creating a FULLTEXT Index that Uses the ngram Parser To create a FULLTEXT ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table-examples.html
row *************************** Table: t1 Create Table: CREATE TABLE `t2` ( `c1` int(11) DEFAULT NULL ) /*!50100 TABLESPACE ts_1 STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1 row in set (0.01 sec) To change ...For NDB tables, it is also possible to change the storage type used for a table or ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbd-definition.html
(NDB 8.0.13) This parameter specifies the directory where all files created for metadata, REDO logs, UNDO logs (for Disk Data tables), and data files are placed. The recommended directory hierarchy for NDB Cluster includes /var/lib/mysql-cluster, ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html
The server creates binary log files in sequence by adding a numeric suffix to the base name. The binary log is a sequence of files with a base name and numeric extension. The --log-bin option value is the base name for the log sequence. For example, ... Startup Options Used with Binary Logging System Variables Used with Binary Logging You can use the mysqld options and system variables that are described in this section to affect the operation of the binary log as well as to control which statements are written to the binary ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-reference.html
Audit Log Functions This section describes, for each audit log function, its purpose, calling sequence, and return value. With an argument consisting of a JSON null value, audit_log_read() closes the current read sequence. If present, the argument ...Unless those objects are installed, the audit_log plugin operates in legacy mode (deprecated in MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/charset-literal.html
Example 1: mysql> SET NAMES latin1; mysql> SELECT HEX('à\n'), HEX(_sjis'à\n'); +------------+-----------------+ | HEX('à\n') | HEX(_sjis'à\n') | +------------+-----------------+ | E00A | E00A | +------------+-----------------+ Here, à ... Every ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode.html
The UTF-8 (Unicode Transformation Format with 8-bit units) method for encoding Unicode data is implemented according to RFC 3629, which describes encoding sequences that take from one to four bytes. The idea of UTF-8 is that various Unicode ... The ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-commands.html
The special character sequences that can be used in the prompt are described later in this section. The string for defining the prompt can contain the following special sequences. There is some overlap in the set of permissible prompt options and ...
https://dev.mysql.com/doc/refman/8.0/en/regexp.html
mysql> SELECT REGEXP_LIKE('fofo', '^f.*$'); -> 1 mysql> SELECT REGEXP_LIKE('fo\r\nfo', '^f.*$'); -> 0 mysql> SELECT REGEXP_LIKE('fo\r\nfo', '^f.*$', 'm'); -> 1 mysql> SELECT REGEXP_LIKE('fo\r\nfo', '(?m)^f.*$'); -> 1 a* Match any sequence of zero or ...This section discusses the functions and operators available for regular expression matching and illustrates, with examples, some of the special characters and constructs that can be used for regular expression ...
https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html
This change applies only to new accounts created after installing or upgrading to MySQL 8.0 or higher. However, the setting should be viewed as temporary, not as a long term or permanent solution, because it causes new accounts created with the ...