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/temporary-table-problems.html
For example, the following does not work: SELECT * FROM temp_table JOIN temp_table AS t2; The statement produces this error: ERROR 1137: Can't reopen table: 'temp_table' You can work around this issue if your query permits use of a common table ...
https://dev.mysql.com/doc/refman/8.0/en/upgrade-binary-package.html
In this case, you should remove all redo log files, start your MySQL 5.7 server on the same data directory, and fix the cause of any errors. For example: mysqladmin -u root -p shutdown mysqld_safe --user=mysql --datadir=/path/to/existing-datadir & ... This section describes how to upgrade MySQL binary and package-based installations on ...
https://dev.mysql.com/doc/refman/8.0/en/using-encrypted-connections.html
If the server automatically enables encrypted connection support, it writes a note to the error log. If the server discovers that the CA certificate is self-signed, it writes a warning to the error log. By default, the RELOAD TLS action rolls back ... Several configuration parameters are available to indicate whether to use encrypted connections, and to specify the appropriate certificate and key ...
https://dev.mysql.com/doc/refman/8.0/en/with.html
(If no CTE refers to itself, RECURSIVE is permitted but not required.) If you forget RECURSIVE for a recursive CTE, this error is a likely result: ERROR 1146 (42S02): Table 'cte_name' doesn't exist The recursive CTE subquery has two parts, separated ... A common table expression (CTE) is a named temporary result set that exists within the scope of a single statement and that can be referred to later within that statement, possibly multiple ...
https://dev.mysql.com/doc/refman/8.0/en/x-plugin-connection-compression.html
required: Compression algorithm negotiation occurs as for preferred mode, but if no common algorithm is available, the connection request terminates with an error. If the compression mode is required but no algorithm permitted on the client side is ... From MySQL 8.0.19, X Plugin supports compression of messages sent over X Protocol ...
https://dev.mysql.com/doc/refman/8.0/en/adding-collation-simple-8bit.html
</charset> In the latin1.xml configuration file, add a <collation> element that names the collation and that contains a <map> element that defines a character code-to-weight mapping table for character codes 0 to 255. This section describes how to ...
https://dev.mysql.com/doc/refman/8.0/en/apis-python.html
See MySQL Connector/Python Developer Guide for details on the Connector, as well as coding guidelines for Python applications and sample Python code. MySQLdb is a third-party driver that provides MySQL support for Python, compliant with the Python ...
https://dev.mysql.com/doc/refman/8.0/en/bnl-bka-optimization.html
In MySQL, a Batched Key Access (BKA) Join algorithm is available that uses both index access to the joined table and a join buffer. The BKA algorithm supports inner join, outer join, and semijoin operations, including nested outer joins. Benefits ...
https://dev.mysql.com/doc/refman/8.0/en/charset-binary-collations.html
utf8mb4 is an exception that has two binary collations, utf8mb4_bin and utf8mb4_0900_bin; see Section 12.10.1, “Unicode Character Sets”. For _bin collations, this ordering is based on numeric character code values, which is similar to ordering ... This section describes how the binary collation for binary strings compares to _bin collations for nonbinary ...
https://dev.mysql.com/doc/refman/8.0/en/charset-collation-names.html
utf8mb4_turkish_ci and utf8mb4_hungarian_ci are similar but based on a less recent version of the Unicode Collation Algorithm. For the _bin collation of a nonbinary character set, comparisons are based on numeric character code values, which differ ... MySQL collation names follow these conventions: A collation name starts with the name of the character set with which it is associated, generally followed by one or more suffixes indicating other collation ...