Couchbase
is distributed NoSQL cloud database.
CREATE SCOPE royaltypool.raihan;
CREATE COLLECTION royaltypool.raihan.client;
CREATE PRIMARY INDEX `default` ON`royaltypool`.`raihan`.`client`
INSERT INTO royaltypool.raihan.client (KEY, VALUE) VALUES('airline_4485',
{ "callsign": "MY-AIR",
"country": "United States",
"iata": "Z1",
"icao": "AQZ",
"name": "80-My Air",
"id": "4444",
"type": "airline"} )
INSERT INTO `royaltypool`.raihan.client (KEY,VALUE)
VALUES ( "airline_4444",
{ "callsign": "MY-AIR",
"country": "United States",
"iata": "Z1",
"icao": "AQZ",
"name": "80-My Air",
"id": "4444",
"type": "airline"} ),
VALUES ( "airline_4445",
{ "callsign": "AIR-X",
"country": "United States",
"iata": "X1",
"icao": "ARX",
"name": "10-AirX",
"id": "4445",
"type": "airline"} )
RETURNING *;
SELECT * FROM royaltypool.raihan.client WHERE id='4444'
UPDATE royaltypool.raihan.client SET country = "Bangladesh" WHERE id = "4444"
DELETE FROM royaltypool.raihan.client WHERE id='4444'