PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/ansi-diff-update.html
The second assignment in the following statement sets col2 to the current (updated) col1 value, not the original col1 value. If you access a column from the table to be updated in an expression, UPDATE uses the current value of the column. The ...
https://dev.mysql.com/doc/refman/8.0/en/bit-functions.html
Table 14.17 Bit Functions and Operators Name Description & Bitwise AND >> Right shift << Left shift ^ Bitwise XOR BIT_COUNT() Return the number of bits that are set | Bitwise OR ~ Bitwise inversion The following list describes available bit ...
https://dev.mysql.com/doc/refman/8.0/en/case.html
For the second syntax, each WHEN clause search_condition expression is evaluated until one is true, at which point its corresponding THEN clause statement_list executes. CASE case_value WHEN when_value THEN statement_list [WHEN when_value THEN ...
https://dev.mysql.com/doc/refman/8.0/en/channels-startup-options.html
--replica-net-timeout=N or --slave-net-timeout=N This value is set per channel, so that each channel waits for N seconds to check for a broken connection. This section describes startup options which are impacted by the addition of replication ...
https://dev.mysql.com/doc/refman/8.0/en/charset-collation-effect.html
The second column shows the result of the SELECT using the German DIN-1 rule, which says that U-umlaut sorts with U. latin1_swedish_ci latin1_german1_ci latin1_german2_ci Muffler Muffler Müller MX Systems Müller Muffler Müller MX Systems MX ...
https://dev.mysql.com/doc/refman/8.0/en/charset-collation-information-schema.html
A lower_case_table_names setting of 1 or 2 causes the second query to return the same (nonempty) result as the first query. String columns in INFORMATION_SCHEMA tables have a collation of utf8mb3_general_ci, which is case-insensitive. However, for ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-sets.html
If you really want rows sorted by the MySQL rule and secondarily by code point value, it is easy: ORDER BY s1 COLLATE utf32_unicode_ci, s1 COLLATE utf32_bin For supplementary characters based on UCA versions higher than 4.0.0 (for example, ... This ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-failure-handling.html
From MySQL 8.0.24, the Clone idle timeout is set to the default wait_timeout setting, which is 28800 seconds (8 hours). This section describes failure handing at different stages of a cloning operation. If a failure occurs during the prerequisite ...
https://dev.mysql.com/doc/refman/8.0/en/comments.html
In MySQL, the -- (double-dash) comment style requires the second dash to be followed by at least one whitespace or control character, such as a space or tab. MySQL Server supports three comment styles: From a # character to the end of the line.
https://dev.mysql.com/doc/refman/8.0/en/connecting-using-uri-or-key-value-pairs.html
connect-timeout: An integer value used to configure the number of seconds that clients, such as MySQL Shell, wait until they stop trying to connect to an unresponsive MySQL server. This section describes use of URI-like connection strings or ...