Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 41.6Mb
PDF (A4) - 41.7Mb
Man Pages (TGZ) - 262.1Kb
Man Pages (Zip) - 372.2Kb
Info (Gzip) - 4.0Mb
Info (Zip) - 4.0Mb
Excerpts from this Manual

MySQL 8.0 Reference Manual  /  ...  /  MySQL Enterprise Data Masking and De-Identification Function Reference

6.5.4 MySQL Enterprise Data Masking and De-Identification Function Reference

Table 6.40 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