prism-n1ql.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>