PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/fulltext-search.html
Full-text indexes can be used only with InnoDB or MyISAM tables, and can be created only for CHAR, VARCHAR, or TEXT columns. A FULLTEXT index definition can be given in the CREATE TABLE statement when a table is created, or added later using ALTER ... 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 index in MySQL is an index of type ...
https://dev.mysql.com/doc/refman/8.0/en/get-diagnostics.html
GET [CURRENT | STACKED] DIAGNOSTICS { statement_information_item [, statement_information_item] ... (You can also use SHOW WARNINGS or SHOW ERRORS to see conditions or errors.) No special privileges are required to execute GET DIAGNOSTICS. The ...
https://dev.mysql.com/doc/refman/8.0/en/getting-information.html
Extra displays special information about columns: If a column was created with the AUTO_INCREMENT option, the value is auto_increment rather than empty. You can obtain the CREATE TABLE statement necessary to create an existing table using the SHOW ... What if you forget the name of a database or table, or what the structure of a given table is (for example, what its columns are called)? MySQL addresses this problem through several statements that provide information about the databases and tables it ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-frequently-asked-questions.html
What is the group_replication_bootstrap_group option used for? The bootstrap flag instructs a member to create a group and act as the initial seed server. When the group is originally created, or when shutting down and restarting the entire group.
https://dev.mysql.com/doc/refman/8.0/en/group-replication-responses-failure-expel.html
You can use the group_replication_member_expel_timeout system variable, which is available from MySQL 8.0.13, to allow additional time between the creation of a suspicion and the expulsion of the suspect member. A suspicion is created when one ...A ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-secure-user.html
20.6.3.1.1 Replication User With The Caching SHA-2 Authentication Plugin By default, users created in MySQL 8 use Section 8.4.1.2, “Caching SHA-2 Pluggable Authentication”. For more information on RSA key-pairs, see Section 8.3.3, “Creating ...
https://dev.mysql.com/doc/refman/8.0/en/hash-joins.html
If this happens, you should be aware that the join may not succeed if a hash join cannot fit into memory and it creates more files than set for open_files_limit. By default, MySQL (8.0.18 and later) employs hash joins whenever possible. It is ...
https://dev.mysql.com/doc/refman/8.0/en/identifier-case-sensitivity.html
To avoid problems caused by such differences, it is best to adopt a consistent convention, such as always creating and referring to databases and tables using lowercase names. Value Meaning 0 Table and database names are stored on disk using the ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-partitions-table.html
PARTITION_EXPRESSION The expression for the partitioning function used in the CREATE TABLE or ALTER TABLE statement that created the table's current partitioning scheme. For each such row: The SUBPARTITION_NAME, SUBPARTITION_ORDINAL_POSITION, ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-user-attributes-table.html
Attributes are shown exactly as set using CREATE USER and ALTER USER statements with ATTRIBUTE or COMMENT options. For additional information and examples, see CREATE USER Comment and Attribute Options. The currently authenticated account has the ...