Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 43.2Mb
PDF (A4) - 43.3Mb
Man Pages (TGZ) - 296.0Kb
Man Pages (Zip) - 401.3Kb
Info (Gzip) - 4.3Mb
Info (Zip) - 4.3Mb
Excerpts from this Manual

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

8.5.2.3 MySQL Enterprise Data Masking and De-Identification Component Function Reference

Table 8.46 MySQL Enterprise Data Masking and De-Identification Component Functions

Name Description Introduced
gen_blocklist() Perform dictionary term replacement 8.0.33
gen_dictionary() Return random term from dictionary 8.0.33
gen_range() Generate random number within range 8.0.33
gen_rnd_canada_sin() Generate random Canada Social Insurance Number 8.0.33
gen_rnd_email() Generate random email address 8.0.33
gen_rnd_iban() Generate random International Bank Account Number 8.0.33
gen_rnd_pan() Generate random payment card Primary Account Number 8.0.33
gen_rnd_ssn() Generate random US Social Security Number 8.0.33
gen_rnd_uk_nin() Generate random United Kingdom National Insurance Number 8.0.33
gen_rnd_us_phone() Generate random US phone number 8.0.33
gen_rnd_uuid() Generate random Universally Unique Identifier 8.0.33
mask_canada_sin() Mask Canada Social Insurance Number 8.0.33
mask_iban() Mask International Bank Account Number 8.0.33
mask_inner() Mask interior part of string 8.0.33
mask_outer() Mask left and right parts of string 8.0.33
mask_pan() Mask payment card Primary Account Number part of string 8.0.33
mask_pan_relaxed() Mask payment card Primary Account Number part of string 8.0.33
mask_ssn() Mask US Social Security Number 8.0.33
mask_uk_nin() Mask United Kingdom National Insurance Number 8.0.33
mask_uuid() Mask Universally Unique Identifier part of string 8.0.33
masking_dictionary_remove() Remove dictionary from the database table 8.0.33
masking_dictionary_term_add() Add new term to the dictionary 8.0.33
masking_dictionary_term_remove() Remove existing term from the dictionary 8.0.33