I am in need to move a large amount of docs between two buckets on the same server. Based on the sample found INSERT INTO `travel-sample` (KEY UUID(), VALUE _country) SELECT _country FROM `travel-sample` _country WHERE type = "airport" AND airportname = "Heathrow" RETURNING *; i was wond…

Insert Select to move between buckets

aponnath February 17, 2020, 2:04am 3

What would the syntax be if i want to add 2 objects like _type and _id.
There wont be a duplicate key issue as its a one time import into a different bucket

Topic		Replies	Views
Insert Data from another bucket using Query workbench SQL++ n1ql	7	3898	April 26, 2016
Insert into from another bucket loads only one record SQL++ query , n1ql	5	584	May 21, 2023
N1QL Query for copying data from one bucket to another SQL++ query	2	1881	January 6, 2022
Transfer part of the document and insert into another document (from a new bucket) in a new format SQL++	1	540	January 26, 2020
Fastest way to copy document and modify content before saving SQL++ n1ql , dot-net	2	1303	April 19, 2022

Insert Select to move between buckets

Related topics