<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="set-statement">
      </a>
      15.7.6 SET Statements
     </h3>
    </div>
   </div>
  </div>
  <div class="toc">
   <dl class="toc">
    <dt>
     <span class="section">
      <a href="set-variable.html">
       15.7.6.1 SET Syntax for Variable Assignment
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="set-character-set.html">
       15.7.6.2 SET CHARACTER SET Statement
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="set-names.html">
       15.7.6.3 SET NAMES Statement
      </a>
     </span>
    </dt>
   </dl>
  </div>
  <p>
   The
   <a class="link" href="set-statement.html" title="15.7.6 SET Statements">
    <code class="literal">
     SET
    </code>
   </a>
   statement has several forms. Descriptions for those forms that are
      not associated with a specific server capability appear in
      subsections of this section:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <a class="link" href="set-variable.html" title="15.7.6.1 SET Syntax for Variable Assignment">
       <code class="literal">
        SET
        <em class="replaceable">
         <code>
          var_name
         </code>
        </em>
        =
        <em class="replaceable">
         <code>
          value
         </code>
        </em>
       </code>
      </a>
      enables you to
          assign values to variables that affect the operation of the
          server or clients. See
      <a class="xref" href="set-variable.html" title="15.7.6.1 SET Syntax for Variable Assignment">
       Section 15.7.6.1, “SET Syntax for Variable Assignment”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="link" href="set-character-set.html" title="15.7.6.2 SET CHARACTER SET Statement">
       <code class="literal">
        SET CHARACTER SET
       </code>
      </a>
      and
      <a class="link" href="set-names.html" title="15.7.6.3 SET NAMES Statement">
       <code class="literal">
        SET NAMES
       </code>
      </a>
      assign values to
          character set and collation variables associated with the
          current connection to the server. See
      <a class="xref" href="set-character-set.html" title="15.7.6.2 SET CHARACTER SET Statement">
       Section 15.7.6.2, “SET CHARACTER SET Statement”
      </a>
      , and
      <a class="xref" href="set-names.html" title="15.7.6.3 SET NAMES Statement">
       Section 15.7.6.3, “SET NAMES Statement”
      </a>
      .
     </p>
    </li>
   </ul>
  </div>
  <p>
   Descriptions for the other forms appear elsewhere, grouped with
      other statements related to the capability they help implement:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <a class="link" href="set-default-role.html" title="15.7.1.9 SET DEFAULT ROLE Statement">
       <code class="literal">
        SET DEFAULT ROLE
       </code>
      </a>
      and
      <a class="link" href="set-role.html" title="15.7.1.11 SET ROLE Statement">
       <code class="literal">
        SET ROLE
       </code>
      </a>
      set the default role
          and current role for user accounts. See
      <a class="xref" href="set-default-role.html" title="15.7.1.9 SET DEFAULT ROLE Statement">
       Section 15.7.1.9, “SET DEFAULT ROLE Statement”
      </a>
      , and
      <a class="xref" href="set-role.html" title="15.7.1.11 SET ROLE Statement">
       Section 15.7.1.11, “SET ROLE Statement”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="link" href="set-password.html" title="15.7.1.10 SET PASSWORD Statement">
       <code class="literal">
        SET PASSWORD
       </code>
      </a>
      assigns account
          passwords. See
      <a class="xref" href="set-password.html" title="15.7.1.10 SET PASSWORD Statement">
       Section 15.7.1.10, “SET PASSWORD Statement”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       SET RESOURCE GROUP
      </code>
      assigns threads to a
          resource group. See
      <a class="xref" href="set-resource-group.html" title="15.7.2.4 SET RESOURCE GROUP Statement">
       Section 15.7.2.4, “SET RESOURCE GROUP Statement”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="link" href="set-transaction.html" title="15.3.7 SET TRANSACTION Statement">
       <code class="literal">
        SET
          TRANSACTION ISOLATION LEVEL
       </code>
      </a>
      sets the isolation level
          for transaction processing. See
      <a class="xref" href="set-transaction.html" title="15.3.7 SET TRANSACTION Statement">
       Section 15.3.7, “SET TRANSACTION Statement”
      </a>
      .
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
