Table 6.38 MySQL Enterprise Data Masking and De-Identification 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() | Return random term from dictionary | ||
gen_dictionary_drop() | Remove dictionary from registry | ||
gen_dictionary_load() | Load dictionary into registry | ||
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 |