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/create-table-foreign-keys.html
In NDB 8.0.20 and later, this value no longer has any effect on how such comparisons are made, and they are always done without regard to lettercase. This index might be silently dropped later if you create another index that can be used to enforce ... MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data ...
https://dev.mysql.com/doc/refman/8.0/en/data-size.html
This can result in huge improvements by reducing the amount of data written to and read from disk. If you access a table mostly by searching on a combination of columns, create a single composite index on them rather than a separate index for each ... Design your tables to minimize their space on the ...
https://dev.mysql.com/doc/refman/8.0/en/descending-indexes.html
For InnoDB full-text search, this means that the index required on the FTS_DOC_ID column of the indexed table cannot be defined as a descending index. MySQL supports descending indexes: DESC in an index definition is no longer ignored but causes ...
https://dev.mysql.com/doc/refman/8.0/en/error-message-language.html
This applies to messages the server writes to the error log and sends to clients. To select the language in which the server writes error messages, follow the instructions in this section. The server searches for the error message file using these ... By default, mysqld produces error messages in English, but they can be displayed instead in any of several other languages: Czech, Danish, Dutch, Estonian, French, German, Greek, Hungarian, Italian, Japanese, Korean, Norwegian, Norwegian-ny, Polish, Portuguese, Romanian, Russian, Slovak, Spanish, or ...
https://dev.mysql.com/doc/refman/8.0/en/expressions.html
This section lists the grammar rules that expressions must follow in MySQL and provides additional information about the types of terms that may appear in expressions. Intervals have this syntax: INTERVAL expr unit expr represents a quantity. This ...Expression Syntax Expression Term Notes Temporal Intervals Expression Syntax The following grammar rules define expression syntax in ...
https://dev.mysql.com/doc/refman/8.0/en/full-text-adding-collation.html
This section describes how to add a user-defined collation for full-text searches using the built-in full-text parser. In the following array, this is the element in the fourth row down, third value from the end. Warning User-defined collations are ...
https://dev.mysql.com/doc/refman/8.0/en/group-by-modifiers.html
In this case, each time there is a change in value in any but the last grouping column, the query produces an extra super-aggregate summary row. This row has the year, country, and products columns set to NULL. However, at this point, you cannot ...
https://dev.mysql.com/doc/refman/8.0/en/index-condition-pushdown-optimization.html
If we know a person's zipcode value but are not sure about the last name, we can search like this: SELECT * FROM people WHERE zipcode='95054' AND lastname LIKE '%etrunia%' AND address LIKE '%Main Street%'; MySQL can use the index to scan through ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-table-reference.html
The following table summarizes INFORMATION_SCHEMA InnoDB tables. For greater detail, see the individual table descriptions. Table 28.3 INFORMATION_SCHEMA InnoDB Tables Table Name Description Introduced INNODB_BUFFER_PAGE Pages in InnoDB buffer pool ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-optimization.html
This includes values such as database and table names, table types, and storage engines. Consider this statement, which identifies collations for the utf8mb4 character set: mysql> SELECT COLLATION_NAME FROM ... Applications that monitor databases ...