Couchbase Developer's Guide 2.0 - Chapter 3. Accessing Data with Couchbase SDKs

3.1. Couchbase SDKs and SQL Commands
Prev	Chapter 3. Accessing Data with Couchbase SDKs	Next

3.1. Couchbase SDKs and SQL Commands

Chapter 3. Accessing Data with Couchbase SDKs

3.1. Couchbase SDKs and SQL Commands

Couchbase SDKs support all of the four standard SQL commands used for reading and writing data. These functions in Couchbase have different method names, but they are the functional equivalents of the following SQL commands:

Table 3.1. SQL Commands/Couchbase Commands

SQL Command	Couchbase SDK Method
`INSERT`, to create.	`set` and `add`
`SELECT`, to retrieve/read data.	`get`, multiple-retrieves, and get-and-touch (get and update expiration).
`UPDATE`, to modify data.	`set` with a given key, or `add` with a new key, or `replace` with a key, or `cas`, also known as Check-and-Set. Used to update a value by providing the matching CAS value for the document. There are also methods for incrementing and decrementing numeric values, changing the expiration for a value, as well as pre-pending or appending to stored objects.
`DELETE`, to remove data.	`delete`, deletes information associated with a given key.