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
The functions listed in this section compose JSON values from component elements. JSON_ARRAY([val[, val] ...]) Evaluates a (possibly empty) list of values and returns a JSON array containing those values. mysql> SELECT JSON_ARRAY(1, "abc", NULL, ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-data-locks-table.html
For information about which lock requests are blocked by which held locks, see Section 29.12.13.2, “The data_lock_waits Table”. Example data lock information: mysql> SELECT * FROM performance_schema.data_locks\G *************************** 1.
https://dev.mysql.com/doc/refman/8.0/en/string-comparison-functions.html
Table 14.13 String Comparison Functions and Operators Name Description LIKE Simple pattern matching NOT LIKE Negation of simple pattern matching STRCMP() Compare two strings If a string function is given a binary string as an argument, the ...
https://dev.mysql.com/doc/refman/8.0/en/trigger-syntax.html
To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 15.1.22, “CREATE TRIGGER Statement”, and Section 15.1.34, “DROP TRIGGER Statement”. Here is a simple example that associates a ...
https://dev.mysql.com/doc/refman/8.0/en/column-count-limit.html
This section describes limits on the number of columns in tables and the size of individual rows. Column Count Limits Row Size Limits Column Count Limits MySQL has hard limit of 4096 columns per table, but the effective maximum may be less for a ...
https://dev.mysql.com/doc/refman/8.0/en/hash-joins.html
By default, MySQL (8.0.18 and later) employs hash joins whenever possible. It is possible to control whether hash joins are employed using one of the BNL and NO_BNL optimizer hints, or by setting block_nested_loop=on or block_nested_loop=off as ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-porting-mysql.html
Consider these aspects of memcached applications when adapting an existing MySQL schema or application to use the daemon_memcached plugin: memcached keys cannot contain spaces or newlines, because these characters are used as separators in the ...
https://dev.mysql.com/doc/refman/8.0/en/invisible-indexes.html
MySQL supports invisible indexes; that is, indexes that are not used by the optimizer. The feature applies to indexes other than primary keys (either explicit or implicit). ALTER INDEX operation: ALTER TABLE t1 ALTER INDEX i_idx INVISIBLE; ALTER ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-functions-general-purpose.html
MySQL Server supports a keyring service that enables internal components and plugins to store sensitive information securely for later retrieval. MySQL Server also includes an SQL interface for keyring key management, implemented as a set of ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-functions.html
As of MySQL 8.0.16, MySQL includes built-in SQL functions that format or retrieve Performance Schema data, and that may be used as equivalents for the corresponding sys schema stored functions. The built-in functions can be invoked in any schema ...