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/charset-unicode-sets.html
This section describes the collations available for Unicode character sets and their differentiating properties. This character set is deprecated in MySQL 8.0, and you should use utf8mb4 instead. Deprecated in MySQL 8.0.28; you should expect ...
https://dev.mysql.com/doc/refman/8.0/en/charset-we-sets.html
DIN-1 is called the “dictionary collation” and DIN-2 is called the “phone book collation.” For an example of the effect this has in comparisons or when doing searches, see Section 12.8.6, “Examples of the Effect of Collation”. This means ... Western European character sets cover most West European languages, such as French, Spanish, Catalan, Basque, Portuguese, Italian, Albanian, Dutch, German, Danish, Swedish, Norwegian, Finnish, Faroese, Icelandic, Irish, Scottish, and ...
https://dev.mysql.com/doc/refman/8.0/en/converting-tables-to-innodb.html
From an efficiency perspective, this avoids unnecessary I/O when you issue large numbers of consecutive INSERT, UPDATE, or DELETE statements. From a safety perspective, this allows you to issue a ROLLBACK statement to recover lost or garbled data if ... If you have MyISAM tables that you want to convert to InnoDB for better reliability and scalability, review the following guidelines and tips before ...
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 ...