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/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 ...
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 ...