Database Reference
In-Depth Information
Deleting specific columns
To remove data from a column in Cassandra, rather than setting it to
NULL
, we'll want to
simply delete it from the column. The syntax for CQL's
DELETE
statement allows us to do
just this by specifying one or more specific columns that we want to delete from:
DELETE "location"
FROM "users"
WHERE "username" = 'bob';
We can now check the
users
table again to confirm that
bob
no longer has a location in
his profile: