Database Reference
In-Depth Information
blog_id | id | content |
posted_on | tags | title
-----------+-----------+-----------------+--------------------------+-----------------------+--------------
83cec... | 83f16... | random content8 | 2014-08-13
23:33:00+0530 | {'garbage', 'random'} | random post8
83cec... | 76738... | random content7 | 2014-08-13
23:32:58+0530 | {'garbage', 'random'} | random post7
(2 rows)
You can retrieve the posts on the next page as follows:
cqlsh:weblog> select * from posts where blog_id =
83cec740-22b1-11e4-a4f0-7f1a8b30f852 and id <
76738dc0-2314-11e4-bac7-3f5f68a133d8 order by id desc limit
2;
blog_id | id | content |
posted_on | tags | title
-----------+-----------+-----------------+--------------------------+-----------------------+--------------
83cec... | 6f85d... | random content6 | 2014-08-13
23:32:56+0530 | {'garbage', 'random'} | random post6
83cec... | 684c5... | random content5 | 2014-08-13
23:32:54+0530 | {'garbage', 'random'} | random post5
