Delete data
Data can be deleted from tables. Many different types of data can be deleted from CQL tables.
Inserting and updating data in CQL is really the same thing. Data can be upserted, meaning that the previously stored data is deleted and replaced with the updated data.
- Deleting values from a column or entire row
-
Use the DELETE statement to replace the value in a column with null or to remove an entire row of data.
- Expiring data with time-to-live
-
Use time-to-live (TTL) to expire data in a column or table.