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-conversion.html
Note ALTER TABLE statements which make changes in table or column character sets or collations must be performed using ALGORITHM=COPY. To convert a binary or nonbinary string column to use a particular character set, use ALTER TABLE. For successful ...
https://dev.mysql.com/doc/refman/8.0/en/charset-errors.html
For more information about character_set_results, see Section 12.4, “Connection Character Sets and Collations”. This section describes how the MySQL server uses character sets for constructing error messages. For information about the language ...
https://dev.mysql.com/doc/refman/8.0/en/charset-restrictions.html
In addition, these operators compare characters by their byte values and accented characters may not compare as equal even if a given collation treats them as equal. Identifiers are stored in mysql database tables (user, db, and so forth) using ...
https://dev.mysql.com/doc/refman/8.0/en/check-table.html
Changes are sometimes made to character sets or collations that require table indexes to be rebuilt. option: { FOR UPGRADE | QUICK | FAST | MEDIUM | EXTENDED | CHANGED } CHECK TABLE checks a table or tables for errors. CHECK TABLE can also check ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-check-constraints.html
Prior to MySQL 8.0.16, CREATE TABLE permits only the following limited version of table CHECK constraint syntax, which is parsed and ignored: CHECK (expr) As of MySQL 8.0.16, CREATE TABLE permits the core features of table and column CHECK ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-select.html
Retrained attributes are NULL (or NOT NULL) and, for those columns that have them, CHARACTER SET, COLLATION, COMMENT, and the DEFAULT clause. You can create one table from another by adding a SELECT statement at the end of the CREATE TABLE ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-information-schema.html
In particular, for each INFORMATION_SCHEMA table that is a view on data dictionary tables: The server no longer must create a temporary table for each query of the INFORMATION_SCHEMA table. When the underlying data dictionary tables store values ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html
DATE_FORMAT() returns a string with a character set and collation given by character_set_connection and collation_connection so that it can return month and weekday names containing non-ASCII characters. This section describes the functions that ...
https://dev.mysql.com/doc/refman/8.0/en/engine-condition-pushdown-optimization.html
A string value to be compared with a column must use the same collation as the column. This optimization improves the efficiency of direct comparisons between a nonindexed column and a constant. In such cases, the condition is “pushed down” to ...
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. Expression Syntax Expression Term Notes Temporal Intervals Expression Syntax The ...