Search Results
https://dev.mysql.com/doc/refman/8.4/en/data-masking.html
For information about the similarities and differences, see Table 8.45, “Comparison Between Data-Masking Components and Plugin Elements”. Note MySQL Enterprise Data Masking and De-Identification is an extension included in MySQL Enterprise ...
https://dev.mysql.com/doc/refman/8.4/en/datetime.html
You can specify a time zone offset when inserting a TIMESTAMP or DATETIME value into a table. This section describes their characteristics, how they are similar, and how they differ. MySQL recognizes DATE, DATETIME, and TIMESTAMP values in several ...
https://dev.mysql.com/doc/refman/8.4/en/dbug-package.html
The debug_options value is a sequence of colon-separated fields: field_1:field_2:...:field_N Each field within the value consists of a mandatory flag character, optionally preceded by a + or - character, and optionally followed by a comma-separated ... The MySQL server and most MySQL clients are compiled with the DBUG package originally created by Fred ...
https://dev.mysql.com/doc/refman/8.4/en/ddl-rewriter-installation.html
To install the ddl_rewriter plugin, use the INSTALL PLUGIN statement, adjusting the .so suffix for your platform as necessary: INSTALL PLUGIN ddl_rewriter SONAME 'ddl_rewriter.so'; To verify plugin installation, examine the Information Schema ...
https://dev.mysql.com/doc/refman/8.4/en/declare-cursor.html
For information available through SHOW statements, it is possible in many cases to obtain equivalent information by using a cursor with an INFORMATION_SCHEMA table. DECLARE cursor_name CURSOR FOR select_statement This statement declares a cursor ...
https://dev.mysql.com/doc/refman/8.4/en/describe.html
The DESCRIBE and EXPLAIN statements are synonyms, used either to obtain information about table structure or query execution plans. For more information, see Section 15.7.7.6, “SHOW COLUMNS Statement”, and Section 15.8.2, “EXPLAIN ...
https://dev.mysql.com/doc/refman/8.4/en/do.html
For example, DO id FROM t1 is invalid because it references a table. In most respects, DO is shorthand for SELECT expr, ..., but has the advantage that it is slightly faster when you do not care about the result. DO is useful primarily with ...
https://dev.mysql.com/doc/refman/8.4/en/downgrading.html
Notes Make sure you understand the MySQL release model for MySQL long-term support (LTS) and Innovation releases before proceeding with a downgrade. A replication topology is downgraded by following the rolling downgrade scheme described at Section ...
https://dev.mysql.com/doc/refman/8.4/en/drop-logfile-group.html
(For information on creating log file groups, see Section 15.1.16, “CREATE LOGFILE GROUP Statement”.) Important Before dropping a log file group, you must drop all tablespaces that use that log file group for UNDO logging. DROP LOGFILE GROUP ...
https://dev.mysql.com/doc/refman/8.4/en/drop-spatial-reference-system.html
If the SRID value is used by some column in an existing table, an error occurs. DROP SPATIAL REFERENCE SYSTEM [IF EXISTS] srid srid: 32-bit unsigned integer This statement removes a spatial reference system (SRS) definition from the data dictionary. Example: DROP SPATIAL REFERENCE SYSTEM 4120; If no SRS definition with the SRID value exists, an error occurs unless IF EXISTS is ...