Movatterモバイル変換

MySQL 9.0 Reference Manual

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

Name	Description
`gen_blocklist()`	Perform dictionary term replacement
`gen_dictionary()`	Return random term from dictionary
`gen_range()`	Generate random number within range
`gen_rnd_canada_sin()`	Generate random Canada Social Insurance Number
`gen_rnd_email()`	Generate random email address
`gen_rnd_iban()`	Generate random International Bank Account Number
`gen_rnd_pan()`	Generate random payment card Primary Account Number
`gen_rnd_ssn()`	Generate random US Social Security Number
`gen_rnd_uk_nin()`	Generate random United Kingdom National Insurance Number
`gen_rnd_us_phone()`	Generate random US phone number
`gen_rnd_uuid()`	Generate random Universally Unique Identifier
`mask_canada_sin()`	Mask Canada Social Insurance Number
`mask_iban()`	Mask International Bank Account 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
`mask_uk_nin()`	Mask United Kingdom National Insurance Number
`mask_uuid()`	Mask Universally Unique Identifier part of string
`masking_dictionaries_flush()`	Cause masking_dictionaries cache to be reloaded from table
`masking_dictionary_remove()`	Remove dictionary from the database table
`masking_dictionary_term_add()`	Add new term to the dictionary
`masking_dictionary_term_remove()`	Remove existing term from the dictionary