cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jonathan Ellis (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (CASSANDRA-2567) CQL: DELETE documentation uses UPDATE examples
Date Tue, 26 Apr 2011 21:28:03 GMT

     [ https://issues.apache.org/jira/browse/CASSANDRA-2567?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Jonathan Ellis resolved CASSANDRA-2567.
---------------------------------------

       Resolution: Fixed
    Fix Version/s: 0.8.0

fixed in r1096915

> CQL: DELETE documentation uses UPDATE examples
> ----------------------------------------------
>
>                 Key: CASSANDRA-2567
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-2567
>             Project: Cassandra
>          Issue Type: Bug
>    Affects Versions: 0.8 beta 1
>            Reporter: Cathy Daw
>            Priority: Trivial
>              Labels: cql
>             Fix For: 0.8.0
>
>
> {panel}
> h2. DELETE
> _Synopsis:_
> bc. 
> DELETE [COLUMNS] FROM <COLUMN FAMILY> [USING <CONSISTENCY>] WHERE KEY = keyname1
> DELETE [COLUMNS] FROM <COLUMN FAMILY> [USING <CONSISTENCY>] WHERE KEY IN
(keyname1, keyname2);
> A @DELETE@ is used to perform the removal of one or more columns from one or more rows.
> h3. Specifying Columns
> bc. 
> DELETE [COLUMNS] ...
> Following the @DELETE@ keyword is an optional comma-delimited list of column name terms.
When no column names are specified, the remove applies to the entire row(s) matched by the
"WHERE clause":#deleterows
> h3. Column Family
> bc. 
> DELETE ... FROM <COLUMN FAMILY> ...
> The column family name follows the list of column names.
> h3. Consistency Level
> bc. 
> UPDATE ... [USING <CONSISTENCY>] ...
> Following the column family identifier is an optional "consistency level specification":#consistency.
> h3(#deleterows). Specifying Rows
> bc. 
> UPDATE ... WHERE KEY = keyname1
> UPDATE ... WHERE KEY IN (keyname1, keyname2)
> The @WHERE@ clause is used to determine which row(s) a @DELETE@ applies to.  The first
form allows the specification of a single keyname using the @KEY@ keyword and the @=@ operator.
 The second form allows a list of keyname terms to be specified using the @IN@ notation and
a parenthesized list of comma-delimited keyname terms.
>      
> {panel}

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message