Search Results
https://dev.mysql.com/doc/refman/8.4/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/8.4/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/8.4/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.4/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/8.4/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.4/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.4/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.4/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 ...
https://dev.mysql.com/doc/refman/8.4/en/charset-repertoire.html
Consider the following CONCAT() calls: CONCAT(_ucs2 X'0041', _ucs2 X'0042') CONCAT(_ucs2 X'0041', _ucs2 X'00C2') For the first call, the repertoire is ASCII because both arguments are within the ASCII range. IF(column1 < column2, 'smaller', ... The ...
https://dev.mysql.com/doc/refman/8.4/en/checking-gpg-signature-windows.html
This requires files for both the packaged file, and the signature. Table 2.2 MySQL Package and Signature Files for MySQL Server MSI for Microsoft Windows File Type File Name Distribution file mysql-8.4.6-winx64.msi Signature file ... The Section ...