Skip to content

Instantly share code, notes, and snippets.

@heartofrevel

heartofrevel/gist:1d7f48a241be4e66dbe3a92342daf4c9

Created February 1, 2021 20:01
Show Gist options
  • Save heartofrevel/1d7f48a241be4e66dbe3a92342daf4c9 to your computer and use it in GitHub Desktop.
Save heartofrevel/1d7f48a241be4e66dbe3a92342daf4c9 to your computer and use it in GitHub Desktop.
Download ZIP
ROW with INSERT
Raw
gistfile1.txt
cqlsh:demo> TRUNCATE upsert_test ;
cqlsh:demo> SELECT * from upsert_test ;
name | title
------+-------
(0 rows)
cqlsh:demo> INSERT INTO upsert_test (name, title) VALUES ('Anshul', 'TL');
cqlsh:demo> SELECT * FROM upsert_test ;
name | title
--------+-------
Anshul | TL
(1 rows)
cqlsh:demo> UPDATE upsert_test SET title = null WHERE name = 'Anshul';
cqlsh:demo> SELECT * FROM upsert_test ;
name | title
--------+-------
Anshul | null
(1 rows)
cqlsh:demo>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment