PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/component-loading.html
MySQL supports manual component loading at runtime and automatic loading during server startup. For example: INSTALL COMPONENT 'file://component_validate_password'; UNINSTALL COMPONENT 'file://component_validate_password'; A loader service handles ... Components must be loaded into the server before they can be ...
https://dev.mysql.com/doc/refman/8.0/en/create-database.html
The ENCRYPTION option, introduced in MySQL 8.0.16, defines the default database encryption, which is inherited by tables created in the database. A database in MySQL is implemented as a directory containing files that correspond to tables in the ...
https://dev.mysql.com/doc/refman/8.0/en/declare-condition.html
DECLARE condition_name CONDITION FOR condition_value condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value } The DECLARE ... It can take the following forms: mysql_error_code: An integer literal indicating a MySQL error code. Do not ...CONDITION statement declares a named error condition, associating a name with a condition that needs specific ...
https://dev.mysql.com/doc/refman/8.0/en/document-store-concepts.html
This section explains the concepts introduced as part of using MySQL as a document store. JSON Document Collection CRUD Operations JSON Document A JSON document is a data structure composed of key-value pairs and is the fundamental structure for ...
https://dev.mysql.com/doc/refman/8.0/en/example-storage-engine.html
Its purpose is to serve as an example in the MySQL source code that illustrates how to begin writing new storage engines. To enable the EXAMPLE storage engine if you build MySQL from source, invoke CMake with the -DWITH_EXAMPLE_STORAGE_ENGINE option. To examine the source for the EXAMPLE engine, look in the storage/example directory of a MySQL source ...
https://dev.mysql.com/doc/refman/8.0/en/floating-point-types.html
MySQL uses four bytes for single-precision values and eight bytes for double-precision values. MySQL also supports this optional precision specification, but the precision value in FLOAT(p) is used only to determine storage size. MySQL permits a ...
https://dev.mysql.com/doc/refman/8.0/en/full-text-adding-collation.html
Warning User-defined collations are deprecated; you should expect support for them to be removed in a future version of MySQL. As of MySQL 8.0.33, the server issues a warning for any use of COLLATE user_defined_collation in an SQL statement; a ...
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 ...Full-text indexes can be used only with InnoDB or MyISAM tables, and can be created only for CHAR, VARCHAR, or TEXT ...
https://dev.mysql.com/doc/refman/8.0/en/gis-wkt-functions.html
For example, both of the following function calls are valid: ST_MPointFromText('MULTIPOINT (1 1, 2 2, 3 3)') ST_MPointFromText('MULTIPOINT ((1 1), (2 2), (3 3))') Functions such as ST_GeomFromText() that accept WKT geometry collection arguments ...
https://dev.mysql.com/doc/refman/8.0/en/group-by-functional-dependence.html
The following discussion provides several examples of the ways in which MySQL detects functional dependencies. The examples use the world database, which can be downloaded from https://dev.mysql.com/doc/index-other.html. The examples use this ...