Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-schemata-table.html
The following statements are equivalent: SELECT SCHEMA_NAME AS `Database` FROM INFORMATION_SCHEMA.SCHEMATA [WHERE SCHEMA_NAME LIKE 'wild'] SHOW DATABASES [LIKE 'wild'] You see only those databases for which you have some kind of privilege, unless ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-triggers-table.html
ACTION_STATEMENT The trigger body; that is, the statement executed when the trigger activates. To see information about a table's triggers, you must have the TRIGGER privilege for the table. The TRIGGERS table has these columns: TRIGGER_CATALOG The ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-views-table.html
VIEW_DEFINITION The SELECT statement that provides the definition of the view. Suppose that the original statement was: CREATE VIEW v AS SELECT s2,s1 FROM t WHERE s1 > 5 ORDER BY s1 WITH CHECK OPTION; Then the view definition looks like this: SELECT ...You must have the SHOW VIEW privilege to access this ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-thread_concurrency.html
When there is a limit on the number of threads (when innodb_thread_concurrency is > 0), InnoDB reduces context switching overhead by permitting multiple requests made during the execution of a single SQL statement to enter InnoDB without observing ... InnoDB uses operating system threads to process requests from user ...
https://dev.mysql.com/doc/refman/8.4/en/ipv6-local-connections.html
In addition to the CREATE USER statement, you can issue GRANT statements that give specific privileges to the account, although that is not necessary for the remaining steps in this procedure. Invoke the mysql client to connect to the server using ... The following procedure shows how to configure MySQL to permit IPv6 connections by clients that connect to the local server using the ::1 local host ...
https://dev.mysql.com/doc/refman/8.4/en/json-table-functions.html
This is equivalent to specifying a column as AUTO_INCREMENT in a CREATE TABLE statement, and can be used to distinguish parent rows with the same value for multiple rows generated by a NESTED [PATH] clause. When multiple values are truncated in a ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-aws-plugin.html
This is a one-time operation, performed by executing the following statements, adjusting the .so suffix for your platform as necessary: CREATE FUNCTION keyring_aws_rotate_cmk RETURNS INTEGER SONAME 'keyring_aws.so'; CREATE FUNCTION ... Note The ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-component-installation.html
Check the server error log, correct the configuration issues, and use the ALTER INSTANCE RELOAD KEYRING statement to reload the configuration. Keyring components should be loaded only by using a manifest file, not by using the INSTALL COMPONENT ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-functions-general-purpose.html
MySQL Server supports a keyring service that enables internal components and plugins to store sensitive information securely for later retrieval. MySQL Server also includes an SQL interface for keyring key management, implemented as a set of ...
https://dev.mysql.com/doc/refman/8.4/en/loadable-function-reference.html
The following table lists each function that is loadable at runtime and provides a short description of each one. For a table listing built-in functions and operators, see Section 14.1, “Built-In Function and Operator Reference” For general ...