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/json-creation-functions.html
mysql> SELECT JSON_ARRAY(1, "abc", NULL, TRUE, CURTIME()); +---------------------------------------------+ | JSON_ARRAY(1, "abc", NULL, TRUE, CURTIME()) | +---------------------------------------------+ | [1, "abc", null, true, "11:30:24.000000"] | ... The functions listed in this section compose JSON values from component ...
https://dev.mysql.com/doc/refman/8.0/en/json-utility-functions.html
The key and the value of an object member are separated by a colon followed by a space (': '). Special characters in string scalars and key names are escaped employing the same rules used by the JSON_QUOTE() function. This section documents utility ...
https://dev.mysql.com/doc/refman/8.0/en/linux-installation-yum-repo.html
For example, for: mysql84-community-release-fc42-1.noarch.rpm The installation command adds the MySQL Yum repository to your system's repository list and downloads the GnuPG key to check the integrity of the software packages. See Section 2.1.4.2, ...Before You Start As a popular, open-source software, MySQL, in its original or re-packaged form, is widely installed on many systems from various sources, including different software download sites, software repositories, and so ...
https://dev.mysql.com/doc/refman/8.0/en/lock-tables.html
If you lock a table explicitly with LOCK TABLES, any tables related by a foreign key constraint are opened and locked implicitly. For foreign key checks, a shared read-only lock (LOCK TABLES READ) is taken on related tables. Locking MyISAM tables ...
https://dev.mysql.com/doc/refman/8.0/en/metadata-locking.html
Locks might be acquired in a different order for implicitly used tables (such as tables in foreign key relationships that also must be locked). Metadata locks are extended, as necessary, to tables related by a foreign key constraint to prevent ...
https://dev.mysql.com/doc/refman/8.0/en/myisampack.html
When the table is used later, the server reads into memory the information needed to decompress columns. This results in much better performance when accessing individual rows, because you only have to uncompress exactly one row. MySQL uses mmap() ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-unsupported.html
A number of features supported by other storage engines are not supported for NDB tables. Trying to use any of these features in NDB Cluster does not cause errors in or of itself; however, errors may occur in applications that expects the features ...
https://dev.mysql.com/doc/refman/8.0/en/nested-loop-joins.html
MySQL join buffering has these characteristics: Join buffering can be used when the join is of type ALL or index (in other words, when no possible keys can be used, and a full scan is done, of either the data or index rows, respectively), or range.
https://dev.mysql.com/doc/refman/8.0/en/nonpersistible-system-variables.html
To use X.509, clients must specify the --ssl-key and --ssl-cert options to connect. SET PERSIST and SET PERSIST_ONLY enable global system variables to be persisted to the mysqld-auto.cnf option file in the data directory (see Section 15.7.6.1, ...
https://dev.mysql.com/doc/refman/8.0/en/optimizer-issues.html
To use it, just add the keyword EXPLAIN to the front of your SELECT statement: mysql> EXPLAIN SELECT * FROM t1, t2 WHERE t1.i = t2.i; EXPLAIN is discussed in more detail in Section 15.8.2, “EXPLAIN Statement”. Use ANALYZE TABLE tbl_name to ...