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/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/account-activity-auditing.html
Specifically, do not permit User to be empty (which creates an anonymous-user account), and do not permit pattern characters or netmask notation in Host values. Applications can use the following guidelines to perform SQL-based auditing that ties ...
https://dev.mysql.com/doc/refman/8.0/en/adding-collation-unicode-uca.html
It is not possible to create user-defined UCA collations for utf16le; there is no utf16le_unicode_ci collation that would serve as the basis for such collations. This section describes how to add a UCA collation for a Unicode character set by ...
https://dev.mysql.com/doc/refman/8.0/en/administrative-connection-interface.html
The create_admin_listener_thread system variable enables DBAs to choose at startup whether the administrative interface has its own separate thread. (This is the case if any admin_tls_xxx or admin_ssl_xxx system variable is set to a value different ... As mentioned in Connection Volume Management, to allow for the need to perform administrative operations even when max_connections connections are already established on the interfaces used for ordinary connections, the MySQL server permits a single administrative connection to users who have the CONNECTION_ADMIN privilege (or the deprecated SUPER ...
https://dev.mysql.com/doc/refman/8.0/en/alter-server.html
ALTER SERVER server_name OPTIONS (option [, option] ...) Alters the server information for server_name, adjusting any of the options permitted in the CREATE SERVER statement. For example, to update the USER option: ALTER SERVER s OPTIONS (USER ...
https://dev.mysql.com/doc/refman/8.0/en/ansi-diff-select-into-table.html
For example: INSERT INTO tbl_temp2 (fld_id) SELECT tbl_temp1.fld_order_id FROM tbl_temp1 WHERE tbl_temp1.fld_order_id > 100; Alternatively, you can use SELECT ... The same syntax can also be used inside stored routines using cursors and local ...
https://dev.mysql.com/doc/refman/8.0/en/apache.html
There are programs that let you authenticate your users from a MySQL database and also let you write your log files into a MySQL table.