couchbase
Couchbase
is distributed NoSQL cloud database.
create Scope
CREATE SCOPE royaltypool.raihan;
create collection
CREATE COLLECTION royaltypool.raihan.client;
Primary index
CREATE PRIMARY INDEX `default` ON`royaltypool`.`raihan`.`client`
Insert data
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"} )
Read data
SELECT * FROM royaltypool.raihan.client WHERE id='4444'
Update data
UPDATE royaltypool.raihan.client SET country = "Bangladesh" WHERE id = "4444"
Delete data
DELETE FROM royaltypool.raihan.client WHERE id='4444'