<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="data-masking-component-function-reference">
      </a>
      8.5.2.3 MySQL Enterprise Data Masking and De-Identification Component Function Reference
     </h4>
    </div>
   </div>
  </div>
  <div class="table">
   <a name="idm46045233140832">
   </a>
   <p class="title">
    <b>
     Table 8.46 MySQL Enterprise Data Masking and De-Identification Component Functions
    </b>
   </p>
   <div class="table-contents">
    <table frame="box" rules="all" summary="A reference that lists MySQL Enterprise Data Masking and De-Identification functions.">
     <colgroup>
      <col style="width: 28%"/>
      <col style="width: 71%"/>
     </colgroup>
     <thead>
      <tr>
       <th>
        Name
       </th>
       <th>
        Description
       </th>
      </tr>
     </thead>
     <tbody>
      <tr>
       <td>
        <a class="link" href="data-masking-component-functions.html#function_gen-blocklist">
         <code class="literal">
          gen_blocklist()
         </code>
        </a>
       </td>
       <td>
        Perform dictionary term replacement
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="data-masking-component-functions.html#function_gen-dictionary">
         <code class="literal">
          gen_dictionary()
         </code>
        </a>
       </td>
       <td>
        Return random term from dictionary
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="data-masking-component-functions.html#function_gen-range">
         <code class="literal">
          gen_range()
         </code>
        </a>
       </td>
       <td>
        Generate random number within range
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="data-masking-component-functions.html#function_gen-rnd-canada-sin">
         <code class="literal">
          gen_rnd_canada_sin()
         </code>
        </a>
       </td>
       <td>
        Generate random Canada Social Insurance Number
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="data-masking-component-functions.html#function_gen-rnd-email">
         <code class="literal">
          gen_rnd_email()
         </code>
        </a>
       </td>
       <td>
        Generate random email address
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="data-masking-component-functions.html#function_gen-rnd-iban">
         <code class="literal">
          gen_rnd_iban()
         </code>
        </a>
       </td>
       <td>
        Generate random International Bank Account Number
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="data-masking-component-functions.html#function_gen-rnd-pan">
         <code class="literal">
          gen_rnd_pan()
         </code>
        </a>
       </td>
       <td>
        Generate random payment card Primary Account Number
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="data-masking-component-functions.html#function_gen-rnd-ssn">
         <code class="literal">
          gen_rnd_ssn()
         </code>
        </a>
       </td>
       <td>
        Generate random US Social Security Number
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="data-masking-component-functions.html#function_gen-rnd-uk-nin">
         <code class="literal">
          gen_rnd_uk_nin()
         </code>
        </a>
       </td>
       <td>
        Generate random United Kingdom National Insurance Number
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="data-masking-component-functions.html#function_gen-rnd-us-phone">
         <code class="literal">
          gen_rnd_us_phone()
         </code>
        </a>
       </td>
       <td>
        Generate random US phone number
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="data-masking-component-functions.html#function_gen-rnd-uuid">
         <code class="literal">
          gen_rnd_uuid()
         </code>
        </a>
       </td>
       <td>
        Generate random Universally Unique Identifier
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="data-masking-component-functions.html#function_mask-canada-sin">
         <code class="literal">
          mask_canada_sin()
         </code>
        </a>
       </td>
       <td>
        Mask Canada Social Insurance Number
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="data-masking-component-functions.html#function_mask-iban">
         <code class="literal">
          mask_iban()
         </code>
        </a>
       </td>
       <td>
        Mask International Bank Account Number
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="data-masking-component-functions.html#function_mask-inner">
         <code class="literal">
          mask_inner()
         </code>
        </a>
       </td>
       <td>
        Mask interior part of string
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="data-masking-component-functions.html#function_mask-outer">
         <code class="literal">
          mask_outer()
         </code>
        </a>
       </td>
       <td>
        Mask left and right parts of string
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="data-masking-component-functions.html#function_mask-pan">
         <code class="literal">
          mask_pan()
         </code>
        </a>
       </td>
       <td>
        Mask payment card Primary Account Number part of string
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="data-masking-component-functions.html#function_mask-pan-relaxed">
         <code class="literal">
          mask_pan_relaxed()
         </code>
        </a>
       </td>
       <td>
        Mask payment card Primary Account Number part of string
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="data-masking-component-functions.html#function_mask-ssn">
         <code class="literal">
          mask_ssn()
         </code>
        </a>
       </td>
       <td>
        Mask US Social Security Number
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="data-masking-component-functions.html#function_mask-uk-nin">
         <code class="literal">
          mask_uk_nin()
         </code>
        </a>
       </td>
       <td>
        Mask United Kingdom National Insurance Number
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="data-masking-component-functions.html#function_mask-uuid">
         <code class="literal">
          mask_uuid()
         </code>
        </a>
       </td>
       <td>
        Mask Universally Unique Identifier part of string
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="data-masking-component-functions.html#function_masking-dictionaries-flush">
         <code class="literal">
          masking_dictionaries_flush()
         </code>
        </a>
       </td>
       <td>
        Cause masking_dictionaries cache to be reloaded from table
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="data-masking-component-functions.html#function_masking-dictionary-remove">
         <code class="literal">
          masking_dictionary_remove()
         </code>
        </a>
       </td>
       <td>
        Remove dictionary from the database table
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="data-masking-component-functions.html#function_masking-dictionary-term-add">
         <code class="literal">
          masking_dictionary_term_add()
         </code>
        </a>
       </td>
       <td>
        Add new term to the dictionary
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="data-masking-component-functions.html#function_masking-dictionary-term-remove">
         <code class="literal">
          masking_dictionary_term_remove()
         </code>
        </a>
       </td>
       <td>
        Remove existing term from the dictionary
       </td>
      </tr>
     </tbody>
    </table>
   </div>
   <div class="table-contents">
    <table cellpadding="0" cellspacing="0" style="position: fixed; top: 0px; display: none; left: 401px; width: 739px;">
     <thead>
      <tr>
       <th style="width: 267.016px;">
        Name
       </th>
       <th style="width: 470.984px;">
        Description
       </th>
      </tr>
     </thead>
    </table>
   </div>
  </div>
  <br class="table-break"/>
 </div>
 <br/>
</div>
