Hi I have one document which was already existed in Couchbase DB. In the bucket the “ID ==abc”. And I want to generate same document, but ID should be “abc1”. I don’t understand how to use INSERT SELECT query. Can anyone please explain.
I got following query
INSERT INTO bucket_name (key k, value _v) SELECT META().id || new AS _k, { “myid” : t.id } _v FROM bucket_name t;