MySQL 8.0 Release Notes
MySQL 8.0 Source Code Documentation
Table 8.47 MySQL Enterprise Data Masking and De-Identification Plugin Functions
| Name | Description | Introduced | Deprecated |
|---|---|---|---|
gen_blacklist() |
Perform dictionary term replacement | 8.0.23 | |
gen_blocklist() |
Perform dictionary term replacement | 8.0.23 | |
gen_dictionary_drop() |
Remove dictionary from registry | ||
gen_dictionary_load() |
Load dictionary into registry | ||
gen_dictionary() |
Return random term from dictionary | ||
gen_range() |
Generate random number within range | ||
gen_rnd_email() |
Generate random email address | ||
gen_rnd_pan() |
Generate random payment card Primary Account Number | ||
gen_rnd_ssn() |
Generate random US Social Security Number | ||
gen_rnd_us_phone() |
Generate random US phone number | ||
mask_inner() |
Mask interior part of string | ||
mask_outer() |
Mask left and right parts of string | ||
mask_pan() |
Mask payment card Primary Account Number part of string | ||
mask_pan_relaxed() |
Mask payment card Primary Account Number part of string | ||
mask_ssn() |
Mask US Social Security Number |