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
Displaying 541 to 547
of 547 total results
- « Previous
- 53
- 54
- 55
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/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.0/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.0/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.0/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.0/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 ...