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/error-message-elements.html
These indicate issues of interest to database administrators or that require DBA action. It is MySQL-specific and is not portable to other database systems. This section discusses how error messages originate within MySQL and the elements they ...
https://dev.mysql.com/doc/refman/8.0/en/explain.html
{EXPLAIN | DESCRIBE | DESC} tbl_name [col_name | wild] {EXPLAIN | DESCRIBE | DESC} [explain_type] {explainable_stmt | FOR CONNECTION connection_id} {EXPLAIN | DESCRIBE | DESC} ANALYZE [explain_type] select_stmt explain_type: { FORMAT = format_name ...
https://dev.mysql.com/doc/refman/8.0/en/extended-show.html
INFORMATION_SCHEMA is an information database, so its name is included in the output from SHOW DATABASES. Some extensions to SHOW statements accompany the implementation of INFORMATION_SCHEMA: SHOW can be used to get information about the structure ...
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? libmysql is a C-based API that you can use in C applications to connect with the MySQL database server. It is also itself used as the foundation for drivers for standard ...
https://dev.mysql.com/doc/refman/8.0/en/federated-create-server.html
For reference, the format of the CONNECTION string is as follows: scheme://user_name[:password]@host_name[:port_num]/db_name/tbl_name Description CONNECTION string CREATE SERVER option mysql.servers column Connection scheme scheme wrapper_name ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-bootstrap.html
mysql> CREATE DATABASE test; mysql> USE test; mysql> CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 TEXT NOT NULL); mysql> INSERT INTO t1 VALUES (1, 'Luis'); Check the content of table t1 and the binary log. The process of starting a group for the first ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-use-cases.html
To summarize, MySQL Group Replication guarantees that the database service is continuously available. It is important to understand that although the database service is available, in the event of an unexpected server exit, those clients connected ... Group Replication enables you to create fault-tolerant systems with redundancy by replicating the system state to a set of ...
https://dev.mysql.com/doc/refman/8.0/en/handler.html
If you do not use an alias, but open the table using a table name qualified by the database name, further references must use the unqualified table name. (See Section 17.20, “InnoDB memcached Plugin” for an alternative way to adapt applications ... HANDLER tbl_name OPEN [ [AS] alias] HANDLER tbl_name READ index_name { = | <= | >= | < | > } (value1,value2,...) [ WHERE where_condition ] [LIMIT ...
https://dev.mysql.com/doc/refman/8.0/en/identifier-length.html
This applies to identifiers in table definitions and to identifiers stored in the grant tables in the mysql database. Prior to NDB 8.0.18, NDB Cluster imposed a maximum length of 63 characters for names of databases and tables. The following table ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-triggers-table.html
TRIGGER_SCHEMA The name of the schema (database) to which the trigger belongs. These columns indicate the catalog and schema (database) in which this table occurs, and the table name, respectively. DATABASE_COLLATION The collation of the database ...