Skip to content

Instantly share code, notes, and snippets.

@virtcoder
Last active July 12, 2021 01:15
Show Gist options
  • Save virtcoder/e7f6bf0c3adb16fb9d84fafac34c5f16 to your computer and use it in GitHub Desktop.
Save virtcoder/e7f6bf0c3adb16fb9d84fafac34c5f16 to your computer and use it in GitHub Desktop.
Postgres DB operation
SELECT count(author_id) FROM public.author;
10000000
SELECT * from author WHERE author_id = 7000000;
author_id | first_name | middle_name | last_lame | job | employer | rating | reviews | students | courses | thumbnail | bio | created_at | updated_at
7000000 | Marjorie | Brionna | Grimes | Regional Usability Planner | McCullough | 3.6 | 34863 | 589912 | 35 | https://authors-avatar.s3.amazonaws.com/6000000.jpg | Marjorie Brionna Grimes has a BS in National. | 2021-07-10 11:25:24 |
UPDATE author SET updated_at = created_at where author_id = 7000000;
UPDATE 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment