-
Notifications
You must be signed in to change notification settings - Fork 16
/
Copy pathvalues.html
130 lines (117 loc) · 6.62 KB
/
values.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
122
123
124
125
126
127
128
129
130
<!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.35. VALUES — Presto 0.184 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.184',
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.184 Documentation" href="../index.html" />
<link rel="up" title="8. SQL Statement Syntax" href="../sql.html" />
<link rel="next" title="9. Migration" href="../migration.html" />
<link rel="prev" title="8.34. USE" href="use.html" />
</head>
<body role="document">
<div class="header">
<h1 class="heading"><a href="../index.html">
<span>Presto 0.184 Documentation</span></a></h1>
<h2 class="heading"><span>8.35. VALUES</span></h2>
</div>
<div class="topnav">
<p class="nav">
<span class="left">
« <a href="use.html">8.34. USE</a>
</span>
<span class="right">
<a href="../migration.html">9. Migration</a> »
</span>
</p>
</div>
<div class="content">
<div class="section" id="values">
<h1>8.35. VALUES</h1>
<div class="section" id="synopsis">
<h2>Synopsis</h2>
<div class="highlight-none"><div class="highlight"><pre><span></span>VALUES row [, ...]
</pre></div>
</div>
<p>where <code class="docutils literal"><span class="pre">row</span></code> is a single expression or</p>
<div class="highlight-none"><div class="highlight"><pre><span></span>( column_expression [, ...] )
</pre></div>
</div>
</div>
<div class="section" id="description">
<h2>Description</h2>
<p>Defines a literal inline table.</p>
<p><code class="docutils literal"><span class="pre">VALUES</span></code> can be used anywhere a query can be used (e.g., the <code class="docutils literal"><span class="pre">FROM</span></code> clause
of a <a class="reference internal" href="select.html"><span class="doc">SELECT</span></a>, an <a class="reference internal" href="insert.html"><span class="doc">INSERT</span></a>, or even at the top level). <code class="docutils literal"><span class="pre">VALUES</span></code> creates
an anonymous table without column names, but the table and columns can be named
using an <code class="docutils literal"><span class="pre">AS</span></code> clause with column aliases.</p>
</div>
<div class="section" id="examples">
<h2>Examples</h2>
<p>Return a table with one column and three rows:</p>
<div class="highlight-sql"><div class="highlight"><pre><span></span><span class="k">VALUES</span> <span class="mi">1</span><span class="p">,</span> <span class="mi">2</span><span class="p">,</span> <span class="mi">3</span>
</pre></div>
</div>
<p>Return a table with two columns and three rows:</p>
<div class="highlight-sql"><div class="highlight"><pre><span></span><span class="k">VALUES</span>
<span class="p">(</span><span class="mi">1</span><span class="p">,</span> <span class="s1">'a'</span><span class="p">),</span>
<span class="p">(</span><span class="mi">2</span><span class="p">,</span> <span class="s1">'b'</span><span class="p">),</span>
<span class="p">(</span><span class="mi">3</span><span class="p">,</span> <span class="s1">'c'</span><span class="p">)</span>
</pre></div>
</div>
<p>Return table with column <code class="docutils literal"><span class="pre">id</span></code> and <code class="docutils literal"><span class="pre">name</span></code>:</p>
<div class="highlight-sql"><div class="highlight"><pre><span></span><span class="k">SELECT</span> <span class="o">*</span> <span class="k">FROM</span> <span class="p">(</span>
<span class="k">VALUES</span>
<span class="p">(</span><span class="mi">1</span><span class="p">,</span> <span class="s1">'a'</span><span class="p">),</span>
<span class="p">(</span><span class="mi">2</span><span class="p">,</span> <span class="s1">'b'</span><span class="p">),</span>
<span class="p">(</span><span class="mi">3</span><span class="p">,</span> <span class="s1">'c'</span><span class="p">)</span>
<span class="p">)</span> <span class="k">AS</span> <span class="n">t</span> <span class="p">(</span><span class="n">id</span><span class="p">,</span> <span class="n">name</span><span class="p">)</span>
</pre></div>
</div>
<p>Create a new table with column <code class="docutils literal"><span class="pre">id</span></code> and <code class="docutils literal"><span class="pre">name</span></code>:</p>
<div class="highlight-sql"><div class="highlight"><pre><span></span><span class="k">CREATE</span> <span class="k">TABLE</span> <span class="n">example</span> <span class="k">AS</span>
<span class="k">SELECT</span> <span class="o">*</span> <span class="k">FROM</span> <span class="p">(</span>
<span class="k">VALUES</span>
<span class="p">(</span><span class="mi">1</span><span class="p">,</span> <span class="s1">'a'</span><span class="p">),</span>
<span class="p">(</span><span class="mi">2</span><span class="p">,</span> <span class="s1">'b'</span><span class="p">),</span>
<span class="p">(</span><span class="mi">3</span><span class="p">,</span> <span class="s1">'c'</span><span class="p">)</span>
<span class="p">)</span> <span class="k">AS</span> <span class="n">t</span> <span class="p">(</span><span class="n">id</span><span class="p">,</span> <span class="n">name</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="insert.html"><span class="doc">INSERT</span></a>, <a class="reference internal" href="select.html"><span class="doc">SELECT</span></a></p>
</div>
</div>
</div>
<div class="bottomnav">
<p class="nav">
<span class="left">
« <a href="use.html">8.34. USE</a>
</span>
<span class="right">
<a href="../migration.html">9. Migration</a> »
</span>
</p>
</div>
<div class="footer" role="contentinfo">
</div>
</body>
</html>