Skip to content

Instantly share code, notes, and snippets.

@codysmith287
Last active April 24, 2019 20:17
Show Gist options
  • Select an option

  • Save codysmith287/89c82af9a6badffcbf6a7b96e82eaa08 to your computer and use it in GitHub Desktop.

Select an option

Save codysmith287/89c82af9a6badffcbf6a7b96e82eaa08 to your computer and use it in GitHub Desktop.

Postgres

Query (psql)

SELECT * FROM album_comments WHERE id = 9999999;

Result

   albumId   |     username     |                          comment                                |                           profileimg                              |   id 
-------------+------------------+-----------------------------------------------------------------+-------------------------------------------------------------------+-----------
  5130103    | Franco_Corkery85 | Vero voluptas eligendi minus labore dolores perferendis impedit.| https://s3.amazonaws.com/uifaces/faces/twitter/rtyukmaev/128.jpg  | 9999999     
(1 row)

Cassandra

Query (cqlsh)

SELECT * FROM album_comments WHERE id = 9999999;

Result

   albumId   |                                     comment                                      |   id    |                           profileimg                             | username 
-------------+----------------------------------------------------------------------------------+---------+------------------------------------------------------------------+-----------
  5739911    | Labore molestias quibusdam voluptas assumenda animi veritatis est aspernatur in. | 9999999 | https://s3.amazonaws.com/uifaces/faces/twitter/samscouto/128.jpg | Merl36     
(1 row)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment