PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/shutdown.html
A successful SHUTDOWN sequence consists of checking the privileges, validating the arguments, and sending an OK packet to the client. SHUTDOWN provides an SQL-level interface to the same functionality available using the mysqladmin shutdown command ...
https://dev.mysql.com/doc/refman/8.0/en/subquery-restrictions.html
In general, you cannot modify a table and select from the same table in a subquery. For example, this limitation applies to statements of the following forms: DELETE FROM t WHERE ... FROM t ...); Exception: The preceding prohibition does not apply ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-auto-increment-columns.html
This indicates how much of the sequence of values is “used up.” . This view indicates which tables have AUTO_INCREMENT columns and provides information about those columns, such as the current and maximum column values and the usage ratio ...
https://dev.mysql.com/doc/refman/8.0/en/uninstall-component.html
As a result, unloaded components are not loaded during the startup sequence for subsequent server restarts. A component provides services that are available to the server and other components; see Section 7.5, “MySQL Components”. It requires the ...
https://dev.mysql.com/doc/refman/8.0/en/unix-signal-response.html
Some command interpreters associate certain key sequences with signals, such as Control+C to send a SIGINT signal. On Unix and Unix-like systems, a process can be the recipient of signals sent to it by the root system account or the system account ...
https://dev.mysql.com/doc/refman/8.0/en/window-function-optimization.html
The optimizer processes multiple windows that have the same ordering requirements in sequence, so sorting can be skipped for windows following the first one. Window functions affect the strategies the optimizer considers: Derived table merging for ...
https://dev.mysql.com/doc/refman/8.0/en/aggregate-functions.html
For a faster count, create a counter table and let your application update it according to the inserts and deletes it does. This section describes aggregate functions that operate on sets of values. They are often used with a GROUP BY clause to ...
https://dev.mysql.com/doc/refman/8.0/en/alter-function.html
However, you cannot change the parameters or body of a stored function using this statement; to make such changes, you must drop and re-create the function using DROP FUNCTION and CREATE FUNCTION. (That privilege is granted automatically to the ...
https://dev.mysql.com/doc/refman/8.0/en/alter-procedure.html
However, you cannot change the parameters or body of a stored procedure using this statement; to make such changes, you must drop and re-create the procedure using DROP PROCEDURE and CREATE PROCEDURE. By default, that privilege is granted ... ALTER ...
https://dev.mysql.com/doc/refman/8.0/en/alter-resource-group.html
These attributes are specified the same way as described for CREATE RESOURCE GROUP (see Section 15.7.2.2, “CREATE RESOURCE GROUP Statement”). The name and type attributes are set at group creation time and cannot be modified thereafter with ...