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/xml-functions.html
For both ExtractValue() and UpdateXML(), the XPath locator used must be valid and the XML to be searched must consist of elements which are properly nested and closed. Table 14.16 XML Functions Name Description ExtractValue() Extract a value from ...
https://dev.mysql.com/doc/refman/8.0/en/account-categories.html
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 user is protected from other accounts: A system user can modify both system and regular accounts. A regular account ... As of MySQL 8.0.16, MySQL incorporates the concept of user account categories, based on the SYSTEM_USER ...
https://dev.mysql.com/doc/refman/8.0/en/alter-event.html
This is true for both ALTER EVENT and CREATE EVENT statements. and db_name.event_name notation, as shown here: ALTER EVENT olddb.myevent RENAME TO newdb.myevent; To execute the previous statement, the user executing it must have the EVENT privilege ... 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 characteristics of an existing event without the need to drop and recreate ...
https://dev.mysql.com/doc/refman/8.0/en/arithmetic-functions.html
The result is determined according to the following rules: In the case of -, +, and *, the result is calculated with BIGINT (64-bit) precision if both operands are integers. If both operands are integers and any of them are unsigned, the result is ... 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
The atomic DDL feature is described under the following topics in this section: Supported DDL Statements Atomic DDL Characteristics Changes in DDL Statement Behavior Storage Engine Support Viewing DDL Logs Supported DDL Statements The atomic DDL ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-file-reading.html
If an audit_log_read() argument includes either item, it must include both to completely specify a position or an error occurs. If a hash argument includes both a start item and a bookmark, an error occurs. The audit log plugin supports functions ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-legacy-filtering.html
Legacy Event Filtering by Account Legacy Event Filtering by Status Legacy Event Filtering by Account To filter audited events based on the originating account, set one (not both) of the following system variables at server startup or runtime. By ...
https://dev.mysql.com/doc/refman/8.0/en/blob.html
You can change the message buffer size by changing the value of the max_allowed_packet variable, but you must do so for both the server and your client program. For example, both mysql and mysqldump enable you to change the client-side ... A BLOB is ...
https://dev.mysql.com/doc/refman/8.0/en/charset-connection.html
Conversion may be lossy for characters that are not in both character sets. +--------------------------+--------+ mysql> SHOW SESSION VARIABLES LIKE 'collation_connection'; +----------------------+-------------------+ | Variable_name | Value | ... A ...
https://dev.mysql.com/doc/refman/8.0/en/charset-introducer.html
MySQL determines the character set and collation of a character string literal, hexadecimal literal, or bit-value literal in the following manner: If both _charset_name and COLLATE collation_name are specified, character set charset_name and ... A ...