CodesJava

Easy learning with example program codes

CQL DELETE Data

To delete data from a table in Cassandra, the DELETE command is used.
Syntax:

DELETE FROM <identifier> WHERE <condition>;

Example 1: Delete an entire row.
Employees table:

id	name	salary
1	Adi	50000
2	Bruno	30000
3	Chris	60000
4	Davis	20000
5	Eliza	15000

Query:

DELETE FROM employees WHERE id = 4;

Explanation:
In the above example, we are deleting the row, where the value of ID is 4.
Verify it by using the below command.
SELECT * FROM employees;

Output:

id	name	salary
1	Adi	50000
2	Bruno	30000
3	Chris	60000
5	Eliza	15000

Example 2: Delete a specific value.
Employees table:

id	name	salary
1	Adi	50000
2	Bruno	30000
3	Chris	60000
4	Davis	20000
5	Eliza	15000

Query:

DELETE salary FROM employees WHERE ID = 3;

Explanation:
In the above example, we are deleting the value of the ‘salary’ column, where the value of ID is 3.
Verify it by using the below command.
SELECT * FROM employees;

Output:

id	name	salary
1	Adi	50000
2	Bruno	30000
3	Chris	null
4	Davis	20000
5	Eliza	15000
Please follow and like us:
error









Copyright © 2019 CodesJava DMCA.com Protection Status