MySQL 8.0 Release Notes
MySQL 8.0 Source Code Documentation
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 |