-
Notifications
You must be signed in to change notification settings - Fork 16
/
Copy pathsql.html
138 lines (128 loc) · 8.37 KB
/
sql.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
131
132
133
134
135
136
137
138
<!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>9. SQL Statement Syntax — Presto 335 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: '335',
COLLAPSE_INDEX: false,
FILE_SUFFIX: '.html',
HAS_SOURCE: true,
SOURCELINK_SUFFIX: '.txt'
};
</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="next" title="9.1. ALTER SCHEMA" href="sql/alter-schema.html" />
<link rel="prev" title="8.3. Legacy and New Timestamp" href="language/timestamp.html" />
<script async src="https://www.googletagmanager.com/gtag/js?id=UA-133457846-1"></script>
<script>
window.dataLayer = window.dataLayer || [];
function gtag(){dataLayer.push(arguments);}
gtag('js', new Date());
gtag('config', 'UA-133457846-1');
</script>
</head>
<body>
<div class="header">
<h1 class="heading"><a href="index.html">
<span>Presto 335 Documentation</span></a></h1>
<h2 class="heading"><span>9. SQL Statement Syntax</span></h2>
</div>
<div class="topnav">
<p class="nav">
<span class="left">
« <a href="language/timestamp.html">8.3. Legacy and New Timestamp</a>
</span>
<span class="right">
<a href="sql/alter-schema.html">9.1. ALTER SCHEMA</a> »
</span>
</p>
</div>
<div class="content">
<div class="section" id="sql-statement-syntax">
<h1>9. SQL Statement Syntax<a class="headerlink" href="#sql-statement-syntax" title="Permalink to this headline">#</a></h1>
<p>This chapter describes the SQL syntax used in Presto.</p>
<p>A <a class="reference internal" href="language.html"><span class="doc">reference to the supported SQL data types</span></a> and other
general characteristics is available in a separate chapter.</p>
<p>Advanced users can take it to the next level by <a class="reference internal" href="functions.html"><span class="doc">using numerous SQL
functions and operators</span></a>.</p>
<div class="toctree-wrapper compound">
<ul>
<li class="toctree-l1"><a class="reference internal" href="sql/alter-schema.html">9.1. ALTER SCHEMA</a></li>
<li class="toctree-l1"><a class="reference internal" href="sql/alter-table.html">9.2. ALTER TABLE</a></li>
<li class="toctree-l1"><a class="reference internal" href="sql/alter-view.html">9.3. ALTER VIEW</a></li>
<li class="toctree-l1"><a class="reference internal" href="sql/analyze.html">9.4. ANALYZE</a></li>
<li class="toctree-l1"><a class="reference internal" href="sql/call.html">9.5. CALL</a></li>
<li class="toctree-l1"><a class="reference internal" href="sql/comment.html">9.6. COMMENT</a></li>
<li class="toctree-l1"><a class="reference internal" href="sql/commit.html">9.7. COMMIT</a></li>
<li class="toctree-l1"><a class="reference internal" href="sql/create-role.html">9.8. CREATE ROLE</a></li>
<li class="toctree-l1"><a class="reference internal" href="sql/create-schema.html">9.9. CREATE SCHEMA</a></li>
<li class="toctree-l1"><a class="reference internal" href="sql/create-table.html">9.10. CREATE TABLE</a></li>
<li class="toctree-l1"><a class="reference internal" href="sql/create-table-as.html">9.11. CREATE TABLE AS</a></li>
<li class="toctree-l1"><a class="reference internal" href="sql/create-view.html">9.12. CREATE VIEW</a></li>
<li class="toctree-l1"><a class="reference internal" href="sql/deallocate-prepare.html">9.13. DEALLOCATE PREPARE</a></li>
<li class="toctree-l1"><a class="reference internal" href="sql/delete.html">9.14. DELETE</a></li>
<li class="toctree-l1"><a class="reference internal" href="sql/describe.html">9.15. DESCRIBE</a></li>
<li class="toctree-l1"><a class="reference internal" href="sql/describe-input.html">9.16. DESCRIBE INPUT</a></li>
<li class="toctree-l1"><a class="reference internal" href="sql/describe-output.html">9.17. DESCRIBE OUTPUT</a></li>
<li class="toctree-l1"><a class="reference internal" href="sql/drop-role.html">9.18. DROP ROLE</a></li>
<li class="toctree-l1"><a class="reference internal" href="sql/drop-schema.html">9.19. DROP SCHEMA</a></li>
<li class="toctree-l1"><a class="reference internal" href="sql/drop-table.html">9.20. DROP TABLE</a></li>
<li class="toctree-l1"><a class="reference internal" href="sql/drop-view.html">9.21. DROP VIEW</a></li>
<li class="toctree-l1"><a class="reference internal" href="sql/execute.html">9.22. EXECUTE</a></li>
<li class="toctree-l1"><a class="reference internal" href="sql/explain.html">9.23. EXPLAIN</a></li>
<li class="toctree-l1"><a class="reference internal" href="sql/explain-analyze.html">9.24. EXPLAIN ANALYZE</a></li>
<li class="toctree-l1"><a class="reference internal" href="sql/grant.html">9.25. GRANT</a></li>
<li class="toctree-l1"><a class="reference internal" href="sql/grant-roles.html">9.26. GRANT ROLES</a></li>
<li class="toctree-l1"><a class="reference internal" href="sql/insert.html">9.27. INSERT</a></li>
<li class="toctree-l1"><a class="reference internal" href="sql/prepare.html">9.28. PREPARE</a></li>
<li class="toctree-l1"><a class="reference internal" href="sql/reset-session.html">9.29. RESET SESSION</a></li>
<li class="toctree-l1"><a class="reference internal" href="sql/revoke.html">9.30. REVOKE</a></li>
<li class="toctree-l1"><a class="reference internal" href="sql/revoke-roles.html">9.31. REVOKE ROLES</a></li>
<li class="toctree-l1"><a class="reference internal" href="sql/rollback.html">9.32. ROLLBACK</a></li>
<li class="toctree-l1"><a class="reference internal" href="sql/select.html">9.33. SELECT</a></li>
<li class="toctree-l1"><a class="reference internal" href="sql/set-role.html">9.34. SET ROLE</a></li>
<li class="toctree-l1"><a class="reference internal" href="sql/set-session.html">9.35. SET SESSION</a></li>
<li class="toctree-l1"><a class="reference internal" href="sql/show-catalogs.html">9.36. SHOW CATALOGS</a></li>
<li class="toctree-l1"><a class="reference internal" href="sql/show-columns.html">9.37. SHOW COLUMNS</a></li>
<li class="toctree-l1"><a class="reference internal" href="sql/show-create-schema.html">9.38. SHOW CREATE SCHEMA</a></li>
<li class="toctree-l1"><a class="reference internal" href="sql/show-create-table.html">9.39. SHOW CREATE TABLE</a></li>
<li class="toctree-l1"><a class="reference internal" href="sql/show-create-view.html">9.40. SHOW CREATE VIEW</a></li>
<li class="toctree-l1"><a class="reference internal" href="sql/show-functions.html">9.41. SHOW FUNCTIONS</a></li>
<li class="toctree-l1"><a class="reference internal" href="sql/show-grants.html">9.42. SHOW GRANTS</a></li>
<li class="toctree-l1"><a class="reference internal" href="sql/show-role-grants.html">9.43. SHOW ROLE GRANTS</a></li>
<li class="toctree-l1"><a class="reference internal" href="sql/show-roles.html">9.44. SHOW ROLES</a></li>
<li class="toctree-l1"><a class="reference internal" href="sql/show-schemas.html">9.45. SHOW SCHEMAS</a></li>
<li class="toctree-l1"><a class="reference internal" href="sql/show-session.html">9.46. SHOW SESSION</a></li>
<li class="toctree-l1"><a class="reference internal" href="sql/show-stats.html">9.47. SHOW STATS</a></li>
<li class="toctree-l1"><a class="reference internal" href="sql/show-tables.html">9.48. SHOW TABLES</a></li>
<li class="toctree-l1"><a class="reference internal" href="sql/start-transaction.html">9.49. START TRANSACTION</a></li>
<li class="toctree-l1"><a class="reference internal" href="sql/use.html">9.50. USE</a></li>
<li class="toctree-l1"><a class="reference internal" href="sql/values.html">9.51. VALUES</a></li>
</ul>
</div>
</div>
</div>
<div class="bottomnav">
<p class="nav">
<span class="left">
« <a href="language/timestamp.html">8.3. Legacy and New Timestamp</a>
</span>
<span class="right">
<a href="sql/alter-schema.html">9.1. ALTER SCHEMA</a> »
</span>
</p>
</div>
<div class="footer" role="contentinfo">
</div>
</body>
</html>