Open
Code
Home
Create
List
Home
Create
List
Edit
Title
Content
In this post we will talk about the 20 most important commands in the SQL Cassandra database language: -- 1. CREATE KEYSPACE CREATE KEYSPACE my_keyspace WITH replication = {'class': 'SimpleStrategy', 'replication_factor': 3}; -- 2. USE USE my_keyspace; -- 3. CREATE TABLE CREATE TABLE users ( user_id UUID PRIMARY KEY, name TEXT, age INT, email TEXT ); -- 4. ALTER TABLE ALTER TABLE users ADD city TEXT; -- 5. INSERT INSERT INTO users (user_id, name, age, email) VALUES (uuid(), 'John Doe', 30, 'john@example.com'); -- 6. SELECT SELECT * FROM users WHERE age > 25; -- 7. UPDATE UPDATE users SET email = 'john.doe@example.com' WHERE user_id = 12345; -- 8. DELETE DELETE FROM users WHERE age < 18; -- 9. TRUNCATE TRUNCATE users; -- 10. DESCRIBE KEYSPACES DESCRIBE KEYSPACES; -- 11. DESCRIBE TABLE DESCRIBE TABLE my_keyspace.users; -- 12. DROP KEYSPACE DROP KEYSPACE my_keyspace; -- 13. DROP TABLE DROP TABLE users; -- 14. CREATE INDEX CREATE INDEX ON users (name); -- 15. DROP INDEX DROP INDEX IF EXISTS idx_name ON users; -- 16. GRANT GRANT ALL PERMISSIONS ON KEYSPACE my_keyspace TO my_user; -- 17. REVOKE REVOKE ALL PERMISSIONS ON KEYSPACE my_keyspace FROM my_user; -- 18. SHOW VERSION SHOW VERSION; -- 19. SHOW HOST SHOW HOST; -- 20. HELP HELP; You can copy the entire code block above and use it in your Cassandra client or CQL shell to execute the commands. Remember to adjust any specific values or identifiers, such as keyspace names, table names, user names, and index names, as needed for your setup.
Image
Category
Categories
Front-End
Back-End
Database
DevOps
Others
Password
Back to List