PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/any-in-some-subqueries.html
The expression is TRUE if table t2 contains (21,14,7) because there is a value 7 in t2 that is less than 10. The expression is FALSE if table t2 contains (20,10), or if table t2 is empty. The expression is unknown (that is, NULL) if table t2 ...NOT ...
https://dev.mysql.com/doc/refman/8.0/en/bit-value-literals.html
Due to the difference in result types, the displayed values differ: High-order 0 digits are not displayed for the numeric result. A leading 0b is case-sensitive and cannot be written as 0B. In numeric contexts, MySQL treats a bit literal like an ...
https://dev.mysql.com/doc/refman/8.0/en/channels-commands-single-channel.html
The requester must wait while the transaction is completed and the rotation takes place. This behavior prevents transactions from being split, which is not permitted for Group Replication.
https://dev.mysql.com/doc/refman/8.0/en/charset-asian-sets.html
For example, the Chinese sets must allow for thousands of different characters. The Asian character sets that we support include Chinese, Japanese, Korean, and Thai. See Section 12.10.7.1, “The cp932 Character Set”, for additional information ...For answers to some common questions and problems relating support for Asian character sets in MySQL, see Section A.11, “MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character ...
https://dev.mysql.com/doc/refman/8.0/en/charset-cp932.html
When converting from Unicode back to cp932, one of the code points must be selected. Why is cp932 needed? In MySQL, the sjis character set corresponds to the Shift_JIS character set defined by IANA, which supports JIS X0201 and JIS X0208 characters. (See http://www.iana.org/assignments/character-sets.) However, the meaning of “SHIFT JIS” as a descriptive term has become very vague and it often includes the extensions to Shift_JIS that are defined by various ...
https://dev.mysql.com/doc/refman/8.0/en/charset-general.html
Mix strings with different character sets or collations in the same server, the same database, or even the same table. To use these features effectively, you must know what character sets and collations are available, how to change the defaults, and ...Let's make the distinction clear with an example of an imaginary character ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-utf16.html
Because MySQL must allow for the worst case (that one character requires four bytes) the maximum length of a utf16 column or index is only half of the maximum length for a ucs2 column or index. The utf16 character set is the ucs2 character set with ...
https://dev.mysql.com/doc/refman/8.0/en/creating-many-tables.html
If you have many MyISAM tables in the same database directory, open, close, and create operations are slow. If you execute SELECT statements on many different tables, there is a little overhead when the table cache is full, because for every table ...You can reduce this overhead by increasing the number of entries permitted in the table ...
https://dev.mysql.com/doc/refman/8.0/en/cursor-restrictions.html
Server-side cursors are implemented in the C API using the mysql_stmt_attr_set() function. A server-side cursor enables a result set to be generated on the server side, but not transferred to the client except for those rows that the client ...In ...
https://dev.mysql.com/doc/refman/8.0/en/derived-condition-pushdown-optimization.html
When a derived table cannot be merged into the outer query (for example, if the derived table uses aggregation), pushing the outer WHERE condition down to the derived table should decrease the number of rows that need to be processed and thus speed ... MySQL 8.0.22 and later supports derived condition pushdown for eligible ...