Easy cheats

 ==== MYSQL command

// show databases

show databases;

// select Db

use testdb;

// show tables;

show tables;

// show columns

desc tutorials;

==== Postgres Command

// connect to postgres

psql -U postgres

\l

SELECT datname FROM pg_database WHERE datistemplate = false;

// connect to DB your_database

psql -U postgres -d your_database

==== Docker 

docker ps

// access container via bash

docker exec -it <container_name_or_id> bash

 

==== Postman 

How to get the Token and paste auto to others API request?

Step: add this code to 'Script' Tab, to save the Token from response to the ENV variable

const response = pm.response.json();

pm.environment.set('token', response.access_token);

 ==== Github - use multiple account github in terminal - this command will delete

cmdkey /list:git:https://github.com

cmdkey /delete:git:https://github.com

==== Linux VPS

quyền thư mục: sudo chown -R usera:useragroup /var/www/mywebsite

sudo nginx -t

sudo systemctl reload nginx