<commit_before><!DOCTYPE html>
<html>
<head>
  <meta charset="UTF-8">
  <title>SQL Cheat Sheet</title>
  <link rel="stylesheet" type="text/css" href="../stylesheets/default.css">
  <link rel="stylesheet" type="text/css" href="../stylesheets/blog.css">
</head>

<body>
  <header>
    <A NAME="top">
      <nav class="nav">
        <ul class=>
          <li><a href="http://jp5486.github.io">Home</a></li>
          <li><a href="../about.html">About</a></li>
          <li><a href="index.html">Blog</a></li>
          <li><a href="../portfolio.html">Portfolio</a></li>
          <li><a href="#resume">Resume</a></li>
        </ul>
      </nav>
  </header>

  <main class="h-line">
    <h1>SQL Cheat Sheet</h1>
    <span>
      <h4>Oct 31, 2015</h4>
    </span>


    <article>
      <p>The Basics of any SQL query are the SELECT and FROM commands. SELECT _____(The columns you want to display)</p>
      <p> FROM _____ (the table name being referenced.)</p>
      <p>Quick note. By convention all Commands are capitialized. </p>

      <p></p>

    </article>



    <table>

      <tr>
        <td>SELECT _____</td>
        <td>column name(s) seperated by comma</td>
      </tr>

      <tr>
        <td>FROM _____</td>
        <td>table origin name</td>
      </tr>

      <tr>
        <td>ORDER BY _____ (optional)-DESC</td>
        <td>add DESC to list from highest down </td>
      </tr>


      <tr>
        <td>WHERE _____ [ < , > , =, < > ]</td>
        <td>restrictive CLAUSE using comparison operators</td>
      </tr>

      <tr>
        <td>AND _____ OR _____</td>
        <td>additional comparison operators</td>
      </tr>

<!--     </table>
    <table> -->

      <tr>
        <td>INSERT INTO _____ (_____, _____, _____)</td>
        <td></td>
      </tr>

      <tr>
        <td>VALUES (_____, _____, _____)</td>
        <td></td>
      </tr>
<!-- ______________________________ -->
      <tr>
        <td>UPDATE _____</td>
        <td></td>
      </tr>

      <tr>
        <td>SET _____ = _____, _____=_____</td>
        <td></td>
      </tr>
      <tr>
        <td>(WHERE)_____=_____ OR _____=_____</td>
        <td></td>
      </tr>
      <tr>
        <td>DELETE FROM _____ WHERE _____=_____</td>
        <td></td>
      </tr>
      <tr>
        <td></td>
        <td></td>
      </tr>
<!-- _________________________ -->
      <tr>
        <td>CREATE DATABASE _____</td>
        <td>database name</td>
      </tr>
      <tr>
        <td>DROP DATABASE _____</td>
        <td>database name</td>
      </tr>
      <tr><commit_msg>add missing description fields for SQL cheat sheet<commit_after><!DOCTYPE html>
<html>
<head>
  <meta charset="UTF-8">
  <title>SQL Cheat Sheet</title>
  <link rel="stylesheet" type="text/css" href="../stylesheets/default.css">
  <link rel="stylesheet" type="text/css" href="../stylesheets/blog.css">
</head>

<body>
  <header>
    <A NAME="top">
      <nav class="nav">
        <ul class=>
          <li><a href="http://jp5486.github.io">Home</a></li>
          <li><a href="../about.html">About</a></li>
          <li><a href="index.html">Blog</a></li>
          <li><a href="../portfolio.html">Portfolio</a></li>
          <li><a href="#resume">Resume</a></li>
        </ul>
      </nav>
  </header>

  <main class="h-line">
    <h1>SQL Cheat Sheet</h1>
    <span>
      <h4>Oct 31, 2015</h4>
    </span>



    <table>

      <tr>
        <td>SELECT _____</td>
        <td>column name(s) seperated by comma</td>
      </tr>

      <tr>
        <td>FROM _____</td>
        <td>table origin name</td>
      </tr>

      <tr>
        <td>ORDER BY _____ (optional)-DESC</td>
        <td>add DESC to list from highest down </td>
      </tr>


      <tr>
        <td>WHERE _____ [ < , > , =, < > ]</td>
        <td>restrictive CLAUSE using comparison operators</td>
      </tr>

      <tr>
        <td>AND _____ OR _____</td>
        <td>additional comparison operators</td>
      </tr>

<!--     </table>
    <table> -->

      <tr>
        <td>INSERT INTO _____ (_____, _____, _____)</td>
        <td>target table name (column names)</td>
      </tr>

      <tr>
        <td>VALUES (_____, _____, _____)</td>
        <td>you can skip paramater assignment if data will fill all columns</td>
      </tr>
<!-- ______________________________ -->
      <tr>
        <td>UPDATE _____</td>
        <td>target table</td>
      </tr>

      <tr>
        <td>SET _____ = _____, _____=_____</td>
        <td>used for variable assignment, optional secondary assignments</td>
      </tr>
      <tr>
        <td>(WHERE)_____=_____ OR _____=_____</td>
        <td>conditional statements</td>
      </tr>
      <tr>
        <td>DELETE FROM _____ WHERE _____=_____</td>
        <td>source table with conditional statement</td>
      </tr>
      <tr>
        <td></td>
        <td></td>
      </tr>
<!-- _________________________ -->
      <tr>
        <td>CREATE DATABASE _____</td>
        <td>database name</td>
      </tr>
      <tr>
        <td>DROP DATABASE _____</td>
        <td>database name</td>
      </tr>
      <tr>
{'fraction_non_alphanumeric': 0.18796992481203006, 'fraction_numerical': 0.00593589236248516, 'mean_word_length': 1.8819840364880274, 'pattern_counts': {'":': 0, '<': 287, '<?xml version=': 0, '>': 287, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '4119021', 'n_tokens_mistral': 1849, 'n_tokens_neox': 1721, 'n_words': 372}