-
Notifications
You must be signed in to change notification settings - Fork 16
/
Copy pathinsert.html
121 lines (108 loc) · 6.27 KB
/
insert.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
<!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.21. INSERT — Presto 0.190 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.190',
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.190 Documentation" href="../index.html" />
<link rel="up" title="8. SQL Statement Syntax" href="../sql.html" />
<link rel="next" title="8.22. PREPARE" href="prepare.html" />
<link rel="prev" title="8.20. GRANT" href="grant.html" />
</head>
<body role="document">
<div class="header">
<h1 class="heading"><a href="../index.html">
<span>Presto 0.190 Documentation</span></a></h1>
<h2 class="heading"><span>8.21. INSERT</span></h2>
</div>
<div class="topnav">
<p class="nav">
<span class="left">
« <a href="grant.html">8.20. GRANT</a>
</span>
<span class="right">
<a href="prepare.html">8.22. PREPARE</a> »
</span>
</p>
</div>
<div class="content">
<div class="section" id="insert">
<h1>8.21. 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">'San Francisco'</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">'San Jose'</span><span class="p">),</span> <span class="p">(</span><span class="mi">3</span><span class="p">,</span> <span class="s1">'Oakland'</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">'POLAND'</span><span class="p">,</span> <span class="mi">3</span><span class="p">,</span> <span class="s1">'no comment'</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">'POLAND'</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">
« <a href="grant.html">8.20. GRANT</a>
</span>
<span class="right">
<a href="prepare.html">8.22. PREPARE</a> »
</span>
</p>
</div>
<div class="footer" role="contentinfo">
</div>
</body>
</html>