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/cache-index.html
Creates 2 key caches named kc_fast and kc_slow Assigns the index for partition p0 to the kc_fast key cache and the index for partitions p1 and p3 to the kc_slow key cache; the index for the remaining partition (p2) uses the server's default key ...| ...
https://dev.mysql.com/doc/refman/8.0/en/charset-collation-information-schema.html
However, for values that correspond to objects that are represented in the file system, such as databases and tables, searches in INFORMATION_SCHEMA string columns can be case-sensitive or case-insensitive, depending on the characteristics of the ...
https://dev.mysql.com/doc/refman/8.0/en/comments.html
This syntax differs slightly from standard SQL comment syntax, as discussed in Section 1.6.2.4, “'--' as the Start of a Comment”. This syntax enables a comment to extend over multiple lines because the beginning and closing sequences need not be ... MySQL Server supports three comment styles: From a # character to the end of the ...
https://dev.mysql.com/doc/refman/8.0/en/comp-err.html
It compiles the errmsg.sys file from text-format error information in MySQL source distributions: As of MySQL 8.0.19, the error information comes from the messages_to_error_log.txt and messages_to_clients.txt files in the share directory. --help, -? ... comp_err creates the errmsg.sys file that is used by mysqld to determine the error messages to display for different error ...
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 ...