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/bit-type.html
The maximum combined size of all BIT columns used in a given NDB table must not exceed 4096 bits. The BIT data type is used to store bit values. If you assign a value to a BIT(M) column that is less than M bits long, the value is padded on the left ...
https://dev.mysql.com/doc/refman/8.0/en/bit-value-literals.html
To convert a bit value to printable form, use it in numeric context or use a conversion function such as BIN() or HEX(). A leading 0b is case-sensitive and cannot be written as 0B. In numeric contexts, MySQL treats a bit literal like an integer. To ...
https://dev.mysql.com/doc/refman/8.0/en/can-not-connect-to-server.html
Under Linux or Unix, check your IP tables (or similar) configuration to ensure that the port has not been blocked. A MySQL client on Unix can connect to the mysqld server in two different ways: By using a Unix socket file to connect through a file ...
https://dev.mysql.com/doc/refman/8.0/en/cannot-create.html
If you get an error of the following type for some queries, it means that MySQL cannot create a temporary file for the result set in the temporary directory: Can't create/write to file '\\sqla3fe_0.ism'. The preceding error is a typical message for ...
https://dev.mysql.com/doc/refman/8.0/en/case-sensitivity.html
For nonbinary strings (CHAR, VARCHAR, TEXT), string searches use the collation of the comparison operands. For binary strings (BINARY, VARBINARY, BLOB), comparisons use the numeric values of the bytes in the operands; this means that for alphabetic ...
https://dev.mysql.com/doc/refman/8.0/en/channels-naming-conventions.html
Because channel names are used in the replica's applier metadata repository table, the character set used for these is always UTF-8. This section describes how naming conventions are impacted by replication channels. Each replication channel has a ...
https://dev.mysql.com/doc/refman/8.0/en/channels-startup-options.html
In MySQL 8.0, the FILE setting is deprecated, and TABLE is the default, so the system variables can be omitted. This section describes startup options which are impacted by the addition of replication channels. The master_info_repository and ...
https://dev.mysql.com/doc/refman/8.0/en/charset-charsets.html
To list the available character sets and their default collations, use the SHOW CHARACTER SET statement or query the INFORMATION_SCHEMA CHARACTER_SETS table. There is one subsection for each group of related character sets. To avoid choosing the ...
https://dev.mysql.com/doc/refman/8.0/en/charset-collation-coercibility.html
In the great majority of statements, it is obvious what collation MySQL uses to resolve a comparison operation. For example, in the following cases, it should be clear that the collation is the collation of column x: SELECT x FROM T ORDER BY x; ...
https://dev.mysql.com/doc/refman/8.0/en/charset-configuration.html
To determine which collations are available for each character set, use the SHOW COLLATION statement or query the INFORMATION_SCHEMA COLLATIONS table. The MySQL server has a compiled-in default character set and collation. To change these defaults, ...