33 lines
773 B
HTML
33 lines
773 B
HTML
<h2>Comments</h2>
|
|
<pre><code># /* Multi-line
|
|
comment */</code></pre>
|
|
|
|
<h2>Strings</h2>
|
|
<pre><code>"foo \"bar\" baz"
|
|
'foo \'bar\' baz'
|
|
"Multi-line strings
|
|
are supported"
|
|
'Multi-line strings
|
|
are supported'</code></pre>
|
|
|
|
<h2>Parameters</h2>
|
|
<pre><code> $1 $2 $3 </code></pre>
|
|
|
|
<h2>Operators</h2>
|
|
<pre><code>SELECT 1 AND 1;
|
|
SELECT 1 OR NULL;
|
|
SELECT EXISTS 1;
|
|
SELECT 2 BETWEEN 1 AND 3;</code></pre>
|
|
|
|
<h2>Functions and keywords</h2>
|
|
<pre><code>SELECT COUNT(*) AS total, MAX(foo) AS max_foo
|
|
FROM `my_bucket`
|
|
WHERE `foo` IS NOT NULL;
|
|
CREATE INDEX productName_index1 ON bucket_name(productName, ProductID)
|
|
WHERE type="product" USING GSI
|
|
WITH {"nodes":["node1:8091", "node2:8091", "node3:8091"]};</code></pre>
|
|
|
|
<h2>Identifiers</h2>
|
|
<pre><code>SELECT *
|
|
FROM `my_bucket`;
|
|
</code></pre> |