0.181/sql/insert.html

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
  "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">


<html xmlns="http://www.w3.org/1999/xhtml">
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    
    <title>8.17. INSERT &#8212; Presto 0.181 Documentation</title>
    
    <link rel="stylesheet" href="../_static/presto.css" type="text/css" />
    <link rel="stylesheet" href="../_static/pygments.css" type="text/css" />
    
    <script type="text/javascript">
      var DOCUMENTATION_OPTIONS = {
        URL_ROOT:    '../',
        VERSION:     '0.181',
        COLLAPSE_INDEX: false,
        FILE_SUFFIX: '.html',
        HAS_SOURCE:  true
      };
    </script>
    <script type="text/javascript" src="../_static/jquery.js"></script>
    <script type="text/javascript" src="../_static/underscore.js"></script>
    <script type="text/javascript" src="../_static/doctools.js"></script>
    <link rel="index" title="Index" href="../genindex.html" />
    <link rel="search" title="Search" href="../search.html" />
    <link rel="top" title="Presto 0.181 Documentation" href="../index.html" />
    <link rel="up" title="8. SQL Statement Syntax" href="../sql.html" />
    <link rel="next" title="8.18. RESET SESSION" href="reset-session.html" />
    <link rel="prev" title="8.16. GRANT" href="grant.html" /> 
  </head>
  <body role="document">
<div class="header">
    <h1 class="heading"><a href="../index.html">
        <span>Presto 0.181 Documentation</span></a></h1>
    <h2 class="heading"><span>8.17. INSERT</span></h2>
</div>
<div class="topnav">
    
<p class="nav">
    <span class="left">
        &laquo; <a href="grant.html">8.16. GRANT</a>
    </span>
    <span class="right">
        <a href="reset-session.html">8.18. RESET SESSION</a> &raquo;
    </span>
</p>

</div>
<div class="content">
    
  <div class="section" id="insert">
<h1>8.17. INSERT</h1>
<div class="section" id="synopsis">
<h2>Synopsis</h2>
<div class="highlight-none"><div class="highlight"><pre><span></span>INSERT INTO table_name [ ( column [, ... ] ) ] query
</pre></div>
</div>
</div>
<div class="section" id="description">
<h2>Description</h2>
<p>Insert new rows into a table.</p>
<p>If the list of column names is specified, they must exactly match the list
of columns produced by the query. Each column in the table not present in the
column list will be filled with a <code class="docutils literal"><span class="pre">null</span></code> value. Otherwise, if the list of
columns is not specified, the columns produced by the query must exactly match
the columns in the table being inserted into.</p>
</div>
<div class="section" id="examples">
<h2>Examples</h2>
<p>Load additional rows into the <code class="docutils literal"><span class="pre">orders</span></code> table from the <code class="docutils literal"><span class="pre">new_orders</span></code> table:</p>
<div class="highlight-sql"><div class="highlight"><pre><span></span><span class="k">INSERT</span> <span class="k">INTO</span> <span class="n">orders</span>
<span class="k">SELECT</span> <span class="o">*</span> <span class="k">FROM</span> <span class="n">new_orders</span><span class="p">;</span>
</pre></div>
</div>
<p>Insert a single row into the <code class="docutils literal"><span class="pre">cities</span></code> table:</p>
<div class="highlight-sql"><div class="highlight"><pre><span></span><span class="k">INSERT</span> <span class="k">INTO</span> <span class="n">cities</span> <span class="k">VALUES</span> <span class="p">(</span><span class="mi">1</span><span class="p">,</span> <span class="s1">&#39;San Francisco&#39;</span><span class="p">);</span>
</pre></div>
</div>
<p>Insert multiple rows into the <code class="docutils literal"><span class="pre">cities</span></code> table:</p>
<div class="highlight-sql"><div class="highlight"><pre><span></span><span class="k">INSERT</span> <span class="k">INTO</span> <span class="n">cities</span> <span class="k">VALUES</span> <span class="p">(</span><span class="mi">2</span><span class="p">,</span> <span class="s1">&#39;San Jose&#39;</span><span class="p">),</span> <span class="p">(</span><span class="mi">3</span><span class="p">,</span> <span class="s1">&#39;Oakland&#39;</span><span class="p">);</span>
</pre></div>
</div>
<p>Insert a single row into the <code class="docutils literal"><span class="pre">nation</span></code> table with the specified column list:</p>
<div class="highlight-sql"><div class="highlight"><pre><span></span><span class="k">INSERT</span> <span class="k">INTO</span> <span class="n">nation</span> <span class="p">(</span><span class="n">nationkey</span><span class="p">,</span> <span class="n">name</span><span class="p">,</span> <span class="n">regionkey</span><span class="p">,</span> <span class="k">comment</span><span class="p">)</span>
<span class="k">VALUES</span> <span class="p">(</span><span class="mi">26</span><span class="p">,</span> <span class="s1">&#39;POLAND&#39;</span><span class="p">,</span> <span class="mi">3</span><span class="p">,</span> <span class="s1">&#39;no comment&#39;</span><span class="p">);</span>
</pre></div>
</div>
<p>Insert a row without specifying the <code class="docutils literal"><span class="pre">comment</span></code> column.
That column will be <code class="docutils literal"><span class="pre">null</span></code>:</p>
<div class="highlight-sql"><div class="highlight"><pre><span></span><span class="k">INSERT</span> <span class="k">INTO</span> <span class="n">nation</span> <span class="p">(</span><span class="n">nationkey</span><span class="p">,</span> <span class="n">name</span><span class="p">,</span> <span class="n">regionkey</span><span class="p">)</span>
<span class="k">VALUES</span> <span class="p">(</span><span class="mi">26</span><span class="p">,</span> <span class="s1">&#39;POLAND&#39;</span><span class="p">,</span> <span class="mi">3</span><span class="p">);</span>
</pre></div>
</div>
</div>
<div class="section" id="see-also">
<h2>See Also</h2>
<p><a class="reference internal" href="values.html"><span class="doc">VALUES</span></a></p>
</div>
</div>


</div>
<div class="bottomnav">
    
<p class="nav">
    <span class="left">
        &laquo; <a href="grant.html">8.16. GRANT</a>
    </span>
    <span class="right">
        <a href="reset-session.html">8.18. RESET SESSION</a> &raquo;
    </span>
</p>

</div>

    <div class="footer" role="contentinfo">
    </div>
  </body>
</html>