Database Reference
In-Depth Information
cqlsh:weblog> CREATE INDEX commenter_idx ON comments
(commenter);
cqlsh:weblog> select * from comments where commenter =
'liz@gmail.com';
post_id | id | commenter |
content |
posted_on | title
-------------+-----------+---------------+---------------------------------------------+--------------------------+--------------------------
04722... | d44e0... | liz@gmail.com | Welcome
to weblog application. | 2014-08-13 00:13:01+0530
| New blogger?
c06a4... | be127... | liz@gmail.com | It is too short to
describe the complexity. | 2014-08-13 00:12:53+0530 |
Thoughful article but...
(2 rows)
This completes all the requirements we stated. We did not cover the
update
and
de-
lete
operations. They follow the same pattern as the insertion of records. The developer
needs to make sure that the data is updated or deleted from all the places. So, if you want
to update a post's title, it needs to be done in the
posts
and
category
tables.