Search Results
https://dev.mysql.com/doc/refman/8.4/en/account-activity-auditing.html
To extract the user name or host name part from a CURRENT_USER() or USER() value, use the SUBSTRING_INDEX() function: mysql> SELECT SUBSTRING_INDEX(CURRENT_USER(),'@',1); +---------------------------------------+ | ...Normally, the CURRENT_USER() ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table-partition-operations.html
ALGORITHM=1 causes the server to use the same key-hashing functions as MySQL 5.1 when computing the placement of rows in partitions; ALGORITHM=2 means that the server employs the key-hashing functions implemented and used by default for new KEY ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-object-cache.html
The stored program definition cache partition exists in parallel with the stored procedure and stored function caches that are configured using the stored_program_cache option. The stored_program_cache option sets a soft upper limit for the number ... The dictionary object cache is a shared global cache that stores previously accessed data dictionary objects in memory to enable object reuse and minimize disk ...
https://dev.mysql.com/doc/refman/8.4/en/group-by-modifiers.html
WITH ROLLUP queries, to test whether NULL values in the result represent super-aggregate values, the GROUPING() function is available for use in the select list, HAVING clause, and ORDER BY clause. The GROUP BY clause permits a WITH ROLLUP modifier ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-change-primary.html
This section explains how to change which member of a single-primary group is the primary, using the group_replication_set_as_primary() function, which can be can be run on any member of the group. This safeguard is applied to ensure the group ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-single-primary-mode.html
You can appoint a specific member as the new primary using the group_replication_set_as_primary() function. If you use the group_replication_switch_to_single_primary_mode() function to change a group that was running in multi-primary mode to run in ... In single-primary mode (group_replication_single_primary_mode=ON) the group has a single primary server that is set to read/write ...
https://dev.mysql.com/doc/refman/8.4/en/if.html
Note There is also an IF() function, which differs from the IF statement described here. [ELSE statement_list] END IF The IF statement for stored programs implements a basic conditional construct. The IF statement can have THEN, ELSE, and ELSEIF ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-key-types.html
The permitted key lengths are subject to multiple factors: General keyring loadable-function interface limits (for keys managed using one of the keyring functions described in Section 8.4.4.12, “General-Purpose Keyring Key-Management ... MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/locale-support.html
This variable affects the output from the DATE_FORMAT(), DAYNAME(), and MONTHNAME() functions. The lc_time_names value does not affect the result from FORMAT(), but this function takes an optional third parameter that enables a locale to be ... The ...
https://dev.mysql.com/doc/refman/8.4/en/lock-tables.html
LIKE, CREATE VIEW, DROP VIEW, and DDL statements on stored functions and procedures and events. You can avoid using LOCK TABLES in many cases by using relative updates (UPDATE customer SET value=value+new_value) or the LAST_INSERT_ID() function. You ... LOCK {TABLE | TABLES} tbl_name [[AS] alias] lock_type [, tbl_name [[AS] alias] lock_type] ...