Search Results
https://dev.mysql.com/doc/refman/8.4/en/faqs-triggers.html
Can triggers access tables? A trigger can access both old and new data in its own table. This is because, if both the source and the replica applied the changes from the source and, in addition, the trigger causing these changes were applied on the ...Where can I find the documentation for MySQL 8.4 triggers? ...
https://dev.mysql.com/doc/refman/8.4/en/function-resolution.html
In either case, once both functions exist, it is necessary thereafter to qualify the stored function with a schema name when invoking it; the server assumes in such cases that the unqualified name refers to the loadable function. MySQL supports ...
https://dev.mysql.com/doc/refman/8.4/en/get-diagnostics.html
GET DIAGNOSTICS can obtain either statement or condition information, but not both in the same statement: To obtain statement information, retrieve the desired statement items into target variables. Initially, both diagnostics areas return the same ... GET [CURRENT | STACKED] DIAGNOSTICS { statement_information_item [, statement_information_item] ...
https://dev.mysql.com/doc/refman/8.4/en/gis-data-formats.html
For example, the following statements both use ST_X() to extract the X-coordinate from a Point object. Two standard spatial data formats are used to represent geometry objects in queries: Well-Known Text (WKT) format Well-Known Binary (WKB) format ...
https://dev.mysql.com/doc/refman/8.4/en/grant-tables.html
The password_history table accumulates a sufficient number of nonempty passwords per account to enable MySQL to perform checks against both the account password history length and reuse interval. Automatic pruning of entries that are outside both ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-configuring-consistency-guarantees.html
The BEFORE and BEFORE_AND_AFTER consistency levels can be used on both read-only and read/write transactions. How to Choose a Consistency Level The different consistency levels provide flexibility to both DBAs, who can use them to set up their ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-ip-address-permissions.html
If a host name used as the Group Replication local address for a server instance resolves to both an IPv4 and an IPv6 address, the IPv4 address is preferred for Group Replication connections. If a host name resolves to both an IPv4 and an IPv6 ...
https://dev.mysql.com/doc/refman/8.4/en/json.html
This can happen when either (or both) of the last two conditions from the previous list is not met but the other conditions are satisfied. Let $ refer to this value: {"a fish": "shark", "a bird": "sparrow"} The keys both contain a space and must be ...The JSON data type provides these advantages over storing JSON-format strings in a string column: Automatic validation of JSON documents stored in JSON ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-key-migration.html
The source and destination must differ, and the migration server must support them both. The source and destination must differ, and mysql_migrate_keyring must support them both. A keyring migration copies keys from one keystore to another, ...
https://dev.mysql.com/doc/refman/8.4/en/log-destinations.html
Examples: To write general query log entries to the log table and the log file, use --log_output=TABLE,FILE to select both log destinations and --general_log to enable the general query log. To write general and slow query log entries only to the ...