Description
The documentation on PREPARE STATEMENT page https://developer.couchbase.com/documentation/server/current/n1ql/n1ql-language-reference/prepare.html describes extensively how to use prepare statement using REST API
I was using the Query workbench to test the PREPARE statement functionality as follow:
prepare mq1 as SELECT * from `travel-sample` limit 2;
I then not sure how I will invoke the named prepared statement mq1, so I tried
execute mq1;
that works.
It would be useful to reference the location where we document Using Prepared Statement in Workbench or cbq.
More complicated scenario:
prepare mq2 as SELECT * from `travel-sample` where type = $t limit 2;
I then tried to figure out how to execute mq2 with bind variable value for $t, I could not guess the right syntax.