git config --global user.name "Your Name"

git config --global user.email "your.email@example.com"

Git Configuration

Basic Commands

git checkout --track origin/<branch_name>

git push <remote_name> --delete <branch_name>

Branching

git remote add <remote_name> <repository_url>

git remote set-url origin <repository_url>

Remote Repositories

Stage & Snapshot

git commit --amend -m "new commit message"

Commit

Undoing Changes

Merge

git pull <remote_name> <branch_name> --no-edit

git pull --rebase <remote_name> <branch_name>

Pull

Rebase

Logging

Stash

Tracking path changes

Cherry Pick

Submodules

Connect: mysql -u [username] -p -h [hostname] -P [port_number] [db_name]

FROM > WHERE > GROUP BY > HAVING > SELECT > DISTINCT > ORDER BY > LIMIT

Clauses

"M" refers to the total number of digits you want to store

"N" is the number of digits to be stored after the decimal point

Data Types

CREATE DATABASE database_name [CHARACTER SET utf8];

ALTER DATABASE database_name CHARACTER SET utf8;

Database Operations

CREATE TABLE [IF NOT EXISTS] table_name (column1 datatype COMMENT 'string', ...);

ALTER TABLE table RENAME TO new_table_name

ALTER TABLE table ADD column_name datatype;

ALTER TABLE table ADD column_name datatype FIRST;

ALTER TABLE table ADD column_name datatype AFTER another_field;

ALTER TABLE table CHANGE field1 new_field_name datatype FIRST

ALTER TABLE table CHANGE field1 new_field_name datatype NOT NULL ..

ALTER TABLE table ALTER field1 SET DEFAULT ...

ALTER TABLE table ALTER field1 DROP DEFAULT;

ALTER TABLE table MODIFY field1 datatype NOT NULL ...

ALTER TABLE table MODIFY field1 type1 FIRST;

ALTER TABLE table MODIFY field1 type1 AFTER another_field;

Table Operations

CREATE TABLE table_name (  column1 datatype constraint,  ...);

CREATE TABLE table_name (
  column_name datatype [ UNSIGNED ] [ NULL | NOT NULL ] [DEFAULT default_value] [AUTO_INCREMENT],
  ...);

CREATE TABLE table_name (
  column_name INT AUTO_INCREMENT,
  ...,
  PRIMARY KEY (column_name)
);

CREATE TABLE table_name (
  column_name INT,
  FOREIGN KEY (column_name) REFERENCES other_table(other_column)
);

CREATE TABLE table_name (
  column1 INT,
  column2 INT,
  UNIQUE KEY `key_name` (column1, column2)
);

CREATE TABLE table_name (
  column_name INT,
  CHECK (column_name > 10)
);

CREATE TABLE table_name (
  City varchar(255) DEFAULT 'Danang'
);

CREATE TABLE table_name (
  column_name datatype UNSIGNED,
);

Constraints Operations

INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, ...);

INSERT INTO table_name (column1, column2, ...) VALUES
  (value1, value2, ...),
  (value1, value2, ...);

Insert Operations

UPDATE table_name SET column1 = value1, column2 = value2 WHERE condition;

Update Operations

DELETE FROM table1, table2 WHERE table1.id1 = table2.id2 AND condition

Delete Operations

SELECT column_name AS alias_name FROM table_name;

SELECT column1, column2, ... FROM table_name;

SELECT column1, column2, ... FROM table_name WHERE condition;

SELECT ... FROM ... WHERE condition ORDER BY column1, column2;

SELECT ... FROM ... WHERE condition ORDER BY column1 [ASC|DESC], column2 [ASC|DESC];

SELECT ... FROM ... WHERE condition LIMIT 10;

SELECT ... FROM ... WHERE condition LIMIT [offset,] row_count;

SELECT ... FROM ... WHERE condition LIMIT row_count OFFSET offset

Select Operations

SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column;

SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column AND table1.column2 = table2.column2;

SELECT * FROM table1 LEFT JOIN table2 ON table1.column = table2.column;

SELECT * FROM table1 RIGHT JOIN table2 ON table1.column = table2.column;

Join Operations

SELECT c1, c2 FROM table1 UNION[ALL] SELECT c1, c2 FROM t2;

Union Operations

WHERE column_name BETWEEN value1 AND value2;

WHERE column_name IN (value1, value2, ...);

WHERE column_name NOT IN (value1, value2, ...);

WHERE column_name1 = value AND column_name2 = value;

WHERE column_name1 = value OR column_name2 = value;

Condition Operations

SELECT UCASE(first_name), LCASE(first_name) FROM table_name;

Aggregate Function Operations

SELECT CONCAT(first_name, ' ', last_name) AS 'Name', dept FROM users;

SELECT TIMESTAMPDIFF(MINUTE, '2023-01-01 12:00:00', NOW());

SELECT DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i:%s');

Function Operations

SELECT age, COUNT(age) FROM users GROUP BY age;

SELECT age, COUNT(age) FROM users WHERE age > 20 GROUP BY age;

SELECT age, COUNT(age) FROM users GROUP BY age HAVING count(age) >=2;

Group By

SELECT * FROM table1 WHERE column_name IN (SELECT column_name FROM table2 WHERE condition);

SELECT column_name, COUNT(*) FROM table_name GROUP BY column_name;

Subquery Operations

CREATE INDEX index_name ON table_name (column_name);

CREATE TABLE t1 (col1 VARCHAR(10), col2 VARCHAR(20), INDEX index_name (col1, col2)

CREATE TABLE t1 (col1 VARCHAR(10), col2 VARCHAR(20), INDEX index_name (col1, col2(10))

CREATE INDEX index_name ON table_name (column1, column2, ...);

CREATE UNIQUE INDEX index_name ON table_name (column_name);

CREATE UNIQUE INDEX index_name ON table_name (column1, column2, ...);

Index Operations

Lock Operations

Transaction Operations

mysqldump -u Username -p dbNameYouWant > databasename_backup.sql

Backup Database Operations

mysql -u Username -p dbNameYouWant < databasename_backup.sql;

Import Database Operations

CREATE USER 'user'@'localhost' IDENTIFIED BY 'password';

ALTER USER 'user'@'hostname' IDENTIFIED BY 'newPass';

UPDATE mysql.user SET Password=PASSWORD('new-password-here') WHERE USER='user-name-here' AND Host='host-name-here';

GRANT ALL PRIVILEGES ON base.* TO 'user'@'localhost' IDENTIFIED BY 'password';

GRANT SELECT, INSERT, DELETE ON base.* TO 'user'@'localhost' IDENTIFIED BY 'password';

REVOKE ALL PRIVILEGES ON base.* FROM 'user'@'host'; -- one permission only

REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'user'@'host'; -- all permissions

Users and Privileges

show status where `variable_name` = 'Threads_connected';

Other

MySQL

Connect: psql -U username -d database_name -h localhost -p port_number

CREATE TABLE table_name (
  column_name datatype [ UNSIGNED ] [ NULL | NOT NULL ] [DEFAULT default_value] [SERIAL],
  ...);

CREATE TABLE table_name (
  column_name INT SERIAL,
  ...,
  PRIMARY KEY (column_name)
);

select * from Email where id > 10 and id < 15 FOR UPDATE;

select * from Email where id > 10 and id < 15 FOR SHARE;

LOCK TABLES table_name IN SHARE UPDATE EXCLUSIVE MODE;

LOCK TABLES table_name IN SHARE ROW EXCLUSIVEMODE;

LOCK TABLES table_name IN EXCLUSIVE MODE;

LOCK TABLES table_name IN ACCESS EXCLUSIVE MODE;

LOCK TABLES table_name IN ACCESS SHARE MODE;

LOCK TABLES table_name IN ROW SHARE MODE;

LOCK TABLES table_name IN ROW EXCLUSIVE MODE;

pg_dump -U username -h localhost -p port_number -d database_name -F c -f backup_file.dump

pg_restore -U username -h localhost -p port_number -d database_name -F c -c backup_file.dump

CREATE USER new_user WITH PASSWORD 'your_password';

ALTER USER your_user WITH PASSWORD 'new_password';

GRANT permission_type ON DATABASE db_name to new_user;

PostgreSQL

Navigation

Standard Output

Basics

File and Directory Operations

System

sed 's/<pattern>/<replacement>/g' <filename>

sed -i 's/<pattern>/<replacement>/g' <filename>

File Content

File Viewing and Editing

File Permissions

Pipelines and Redirection

Variables

Shell execution

for i in {1..5}; do
 echo "index: $i"; 
done

for ((i = 0 ; i < 100 ; i++)); do
 echo "index: $i"; 
done

Control Structures

Functions

Miscellaneous

Bash

Docker Basics

Images

Containers

Volumes

Networks

docker inspect --format='{{.Key}} {{.Value}}' <container_or_image>

Docker Inspect

Clean up

services:
  web:
    build:
      context: ./Path
      dockerfile: Dockerfile
    args:
      APP_HOME: app
    ports:
      - "5000:5000"
      - "5001:5001"
    environment:
      APP_ENV: development
    volumes:
      - .:/code
    restart: unless-stopped
    depends_on:
      - db
    entrypoint: /app/start.sh
    entrypoint: [php, -d, vendor/bin/phpunit]
  redis:
    image: redis


Programming Cheatsheets

Git

Git

MySQL

MySQL

PostgreSQL

PostgreSQL

Bash

Bash

Docker

Docker

Windows Command Line

Windows Command Line