Search Results
https://dev.mysql.com/doc/refman/8.4/en/user-variables.html
HAVING, GROUP BY, and ORDER BY, when referring to a variable that is assigned a value in the select expression list do not work as expected because the expression is evaluated on the client and thus can use stale column values from a previous row.
https://dev.mysql.com/doc/refman/8.4/en/view-updatability.html
Some views are updatable and references to them can be used to specify tables to be updated in data change statements. That is, you can use them in statements such as UPDATE, DELETE, or INSERT to update the contents of the underlying table. Derived ...
https://dev.mysql.com/doc/refman/8.4/en/window-function-optimization.html
Window functions affect the strategies the optimizer considers: Derived table merging for a subquery is disabled if the subquery has window functions. Semijoins are not applicable to window function optimization because semijoins apply to ...
https://dev.mysql.com/doc/refman/8.4/en/window-function-restrictions.html
The parser recognizes these window constructs which nevertheless are not supported: The GROUPS frame units specifier is parsed, but produces an error. The SQL standard imposes a constraint on window functions that they cannot be used in UPDATE or ...
https://dev.mysql.com/doc/refman/8.4/en/window-functions-frames.html
The definition of a window used with a window function can include a frame clause. A frame is a subset of the current partition and the frame clause specifies how to define the subset. Frames are determined with respect to the current row, which ...
https://dev.mysql.com/doc/refman/8.4/en/windows-installation.html
This installs the MySQL server, an associated MySQL Configurator application, and it adds related MySQL items to the Microsoft Windows Start menu under the MySQL group. MySQL is available for Microsoft Windows 64-bit operating systems only. There ...
https://dev.mysql.com/doc/refman/8.4/en/working-with-null.html
Two NULL values are regarded as equal in a GROUP BY. The NULL value can be surprising until you get used to it. Conceptually, NULL means “a missing unknown value” and it is treated somewhat differently from other values. In MySQL, 0 or NULL ...
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-status-variables.html
Mysqlx_aborted_clients The number of clients that were disconnected because of an input or output error. Mysqlx_address The network address or addresses for which X Plugin accepts TCP/IP connections. If multiple addresses were specified using the ...
https://dev.mysql.com/doc/refman/8.4/en/xa-states.html
Disabling detached XA transactions is not recommended for a MySQL server instance used in group replication; see Server Instance Configuration, for more information. An XA transaction progresses through the following states: Use XA START to start ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/preface.html
This document contains release notes for the changes in MySQL 8.4. License Restrictions This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual ...