PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/system-variable-privileges.html
(For information about dynamic variables, see Section 7.1.9.2, “Dynamic System Variables”.) For certain global system variables, SET can be used to persist their value to the mysqld-auto.cnf file in the data directory, to affect server operation ...
https://dev.mysql.com/doc/refman/8.0/en/upgrading-what-is-upgraded.html
Installing a new version of MySQL may require upgrading these parts of the existing installation: The mysql system schema, which contains tables that store information required by the MySQL server as it runs (see Section 7.3, “The mysql System ...
https://dev.mysql.com/doc/refman/8.0/en/xml-functions.html
Table 14.16 XML Functions Name Description ExtractValue() Extract a value from an XML string using XPath notation UpdateXML() Return replaced XML fragment This section discusses XML and related functionality in MySQL. Note It is possible to obtain ...
https://dev.mysql.com/doc/refman/8.0/en/account-categories.html
As of MySQL 8.0.16, MySQL incorporates the concept of user account categories, based on the SYSTEM_USER privilege. The SYSTEM_USER privilege has an effect on the accounts to which a given user can apply its other privileges, as well as whether the ...
https://dev.mysql.com/doc/refman/8.0/en/alter-event.html
ALTER [DEFINER = user] EVENT event_name [ON SCHEDULE schedule] [ON COMPLETION [NOT] PRESERVE] [RENAME TO new_event_name] [ENABLE | DISABLE | DISABLE ON SLAVE] [COMMENT 'string'] [DO event_body] The ALTER EVENT statement changes one or more of the ...
https://dev.mysql.com/doc/refman/8.0/en/arithmetic-functions.html
Table 14.9 Arithmetic Operators Name Description %, MOD Modulo operator * Multiplication operator + Addition operator - Minus operator - Change the sign of the argument / Division operator DIV Integer division The usual arithmetic operators are ...
https://dev.mysql.com/doc/refman/8.0/en/atomic-ddl.html
An atomic DDL statement combines the data dictionary updates, storage engine operations, and binary log writes associated with a DDL operation into a single, atomic operation. The operation is either committed, with applicable changes persisted to ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-file-reading.html
The audit log plugin supports functions that provide an SQL interface for reading JSON-format audit log files. (This capability does not apply to log files written in other formats.) When the audit log plugin initializes and is configured for JSON ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-legacy-filtering.html
Note This section describes legacy audit log filtering, which applies if the audit_log plugin is installed without the accompanying audit tables and functions needed for rule-based filtering. Legacy Mode Audit Log Filtering is deprecated as of ...
https://dev.mysql.com/doc/refman/8.0/en/blob.html
A BLOB is a binary large object that can hold a variable amount of data. These differ only in the maximum length of the values they can hold. These correspond to the four BLOB types and have the same maximum lengths and storage requirements. They ...