Search Results
https://dev.mysql.com/doc/refman/8.4/en/data-directory-initialization.html
This is insecure; it is assumed that you intend to assign a password to the account in a timely fashion before putting the server into production use. After MySQL is installed, the data directory must be initialized, including the tables in the ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-component-functions.html
mask_canada_sin(str [, mask_char]) Masks a Canada Social Insurance Number (SIN) and returns the number with all meaningful digits replaced by 'X' characters. Nine digits grouped in pattern: xxx-xxx-xxx ('-' is any separator character). Return value: ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-plugin-function-reference.html
Table 8.47 MySQL Enterprise Data Masking and De-Identification Plugin Functions Name Description Deprecated gen_blacklist() Perform dictionary term replacement Yes gen_blocklist() Perform dictionary term replacement gen_dictionary_drop() Remove ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-plugin-usage.html
Before using MySQL Enterprise Data Masking and De-Identification, install it according to the instructions provided at Section 8.5.3.1, “MySQL Enterprise Data Masking and De-Identification Plugin Installation”. To use MySQL Enterprise Data ...
https://dev.mysql.com/doc/refman/8.4/en/database-use.html
Once you know how to enter SQL statements, you are ready to access a database. Suppose that you have several pets in your home (your menagerie) and you would like to keep track of various types of information about them. You can do so by creating ...
https://dev.mysql.com/doc/refman/8.4/en/date-and-time-type-conversion.html
Conversion of DATETIME and TIMESTAMP values: Conversion to a DATE value takes fractional seconds into account and rounds the time part. To some extent, you can convert a value from one temporal type to another. However, there may be some alteration ...
https://dev.mysql.com/doc/refman/8.4/en/ddl-rewriter.html
For example, the plugin may enable restoring such dump files into an unencrypted instance or in an environment where the paths outside the data directory are not accessible. MySQL 8.4 includes a ddl_rewriter plugin that modifies CREATE TABLE ...
https://dev.mysql.com/doc/refman/8.4/en/declare-cursor.html
DECLARE cursor_name CURSOR FOR select_statement This statement declares a cursor and associates it with a SELECT statement that retrieves the rows to be traversed by the cursor. The number of columns retrieved by the SELECT statement must match the ...
https://dev.mysql.com/doc/refman/8.4/en/deleting-from-related-tables.html
If the total length of the DELETE statement for related_table is more than the default value of the max_allowed_packet system variable, you should split it into smaller parts and execute multiple DELETE statements. You probably get the fastest ...
https://dev.mysql.com/doc/refman/8.4/en/derived-condition-pushdown-optimization.html
When a derived table cannot be merged into the outer query (for example, if the derived table uses aggregation), pushing the outer WHERE condition down to the derived table should decrease the number of rows that need to be processed and thus speed ...Outer WHERE conditions can be pushed down to derived materialized tables under the following circumstances: When the derived table uses no aggregate or window functions, the outer WHERE condition can be pushed down to it ...