PDF (US Ltr)
- 41.9Mb
PDF (A4)
- 42.0Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/system-variable-privileges.html
SET PERSIST_ONLY can be used for both dynamic and read-only system variables, but is particularly useful for persisting read-only variables, for which SET PERSIST cannot be used. (For information about dynamic variables, see Section 7.1.9.2, ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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 ... MySQL incorporates the concept of user account categories, based on the SYSTEM_USER ...
https://dev.mysql.com/doc/refman/9.7/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 ...The syntax for each of the DEFINER, ON SCHEDULE, ON COMPLETION, COMMENT, ENABLE / DISABLE, and DO clauses is exactly the same as when used with CREATE ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/en/atomic-ddl.html
The atomic DDL feature is described under the following topics in this section: Supported DDL Statements Atomic DDL Characteristics DDL Statement Behavior Storage Engine Support Viewing DDL Logs Supported DDL Statements The atomic DDL feature ...An ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-component-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 component supports ...
https://dev.mysql.com/doc/refman/9.7/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. Important The audit_log plugin is ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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 ...