Search Results
https://dev.mysql.com/doc/refman/8.4/en/alter-table-partition-operations.html
Partitioning-related clauses for ALTER TABLE can be used with partitioned tables for repartitioning, to add, drop, discard, import, merge, and split partitions, and to perform partitioning maintenance. Any data that was stored in the dropped ...
https://dev.mysql.com/doc/refman/8.4/en/extensions-to-ansi.html
See Section 15.1.12, “CREATE DATABASE Statement”, Section 15.1.24, “DROP DATABASE Statement”, and Section 15.1.2, “ALTER DATABASE Statement”. Organization of data on disk MySQL Server maps each database to a directory under the MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/enterprise-encryption-installation.html
The functions are provided by a MySQL component component_enterprise_encryption, and installing the component installs all of the functions. MySQL Enterprise Encryption functions are provided by the MySQL component_enterprise_encryption component.
https://dev.mysql.com/doc/refman/8.4/en/innodb-parameters.html
Table creation and drop operations for any storage engine modify data dictionary tables in the mysql system database, but those tables use the InnoDB storage engine and cannot be modified when innodb_read_only is enabled. Some options, which you ...
https://dev.mysql.com/doc/refman/8.4/en/alter-user.html
ALTER USER Multifactor Authentication Options ALTER USER has ADD, MODIFY, and DROP clauses that enable authentication factors to be added, modified, or dropped. When ALTER USER adds, modifies, or drops second and third factors in a single statement, ... ALTER USER [IF EXISTS] user [auth_option] [, user [auth_option]] ...
https://dev.mysql.com/doc/refman/8.4/en/handler-scope.html
However, SQLSTATE handlers take precedence over SQLEXCEPTION handlers, so if the table t is nonexistent, the DROP TABLE statement raises a condition that activates the SQLSTATE handler: mysql> CALL p1(); +--------------------------------+ | msg | ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/adding-loadable-function.html
To use CREATE FUNCTION or DROP FUNCTION, you must have the INSERT or DELETE privilege, respectively, for the mysql database. To remove functions, use DROP FUNCTION: DROP FUNCTION metaphon; DROP FUNCTION myfunc_double; DROP FUNCTION myfunc_int; DROP ... The MySQL interface for loadable functions provides the following features and capabilities: Functions can return string, integer, or real values and can accept arguments of those same ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-file-formats.html
<AUDIT_RECORD> <TIMESTAMP>2019-10-03T14:09:38 UTC</TIMESTAMP> <RECORD_ID>6_2019-10-03T14:06:33</RECORD_ID> <NAME>Query</NAME> <CONNECTION_ID>5</CONNECTION_ID> <STATUS>0</STATUS> <STATUS_CODE>0</STATUS_CODE> <USER>root[root] @ localhost ... The MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/stored-objects-security.html
An existing stored object can become orphaned through execution of a DROP USER statement that drops the object DEFINER account, or a RENAME USER statement that renames the object DEFINER account. (That is, the statement fails if dropping an account ... Stored programs (procedures, functions, triggers, and events) and views are defined prior to use and, when referenced, execute within a security context that determines their ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/glossary.html
MySQL Enterprise Backup A licensed products that performs hot backups of MySQL database servers. Backups are further classified as hot, warm, or cold depending on how much they interfere with normal database server operation. These statements can be ... These terms are commonly used in information about the MySQL Enterprise Backup ...