PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.1Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/create-function-loadable.html
(CREATE FUNCTION is also used to created stored functions; see Section 15.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”.) A loadable function is a way to extend MySQL with a new function that works like a native (built-in) MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/create-temporary-table.html
A TEMPORARY table is visible only within the current session, and is dropped automatically when the session is closed. If innodb_strict_mode is disabled, warnings are issued and the temporary table is created using a non-compressed row format. The ... You can use the TEMPORARY keyword when creating a ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary.html
In previous MySQL releases, dictionary data was stored in metadata files, nontransactional tables, and storage engine-specific data dictionaries. This chapter describes the main features, benefits, usage differences, and limitations of the data ...
https://dev.mysql.com/doc/refman/8.0/en/document-store-concepts.html
CRUD Operations The four basic operations that can be issued against a collection are Create, Read, Update and Delete (CRUD). JSON Document Collection CRUD Operations JSON Document A JSON document is a data structure composed of key-value pairs and ... This section explains the concepts introduced as part of using MySQL as a document ...
https://dev.mysql.com/doc/refman/8.0/en/document-store-interfaces.html
You can use MySQL Shell to prototype applications, execute queries and update data. To work with MySQL as a document store, you use dedicated components and a choice of clients that support communicating with the MySQL server to develop document ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-c-api.html
What is “MySQL Native C API”? What are typical benefits and use cases? A.13.2. What is “MySQL Native C API”? What are typical benefits and use cases? libmysql is a C-based API that you can use in C applications to connect with the MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/federated-create-connection.html
This user must have been created on the remote server, and must have suitable privileges to perform the required actions (SELECT, INSERT, UPDATE, and so forth) on the remote table. The connection string specifies the server name, login credentials, ... To use the first method, you must specify the CONNECTION string after the engine type in a CREATE TABLE ...
https://dev.mysql.com/doc/refman/8.0/en/fixed-point-types.html
The DECIMAL and NUMERIC types store exact numeric data values. In a DECIMAL column declaration, the precision and scale can be (and usually is) specified. For example: salary DECIMAL(5,2) In this example, 5 is the precision and 2 is the scale. The ...These types are used when it is important to preserve exact precision, for example with monetary ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-query-expansion.html
Full-text search supports query expansion (and in particular, its variant “blind query expansion”). For example, a user searching for “database” may really mean that “MySQL”, “Oracle”, “DB2”, and “RDBMS” all are phrases that ...This is generally useful when a search phrase is too short, which often means that the user is relying on implied knowledge that the full-text search engine ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-distributed-recovery-fault.html
In the following situations, Group Replication detects an error in distributed recovery, automatically switches over to a new donor, and retries the state transfer: Connection error - There is an authentication issue or another problem with making ...The donor for distributed recovery is selected randomly from the existing list of suitable online group members in the current ... Group Replication's ...