Show Menu
Cheatography

Programming Cheat Sheet Cheat Sheet (DRAFT) by [deleted]

This is a draft cheat sheet. It is a work in progress and is not finished yet.

MySQL

Descri­ption
Command
Change column name
ALTER TABLE (tbl_name) CHANGE COLUMN (old_c­olu­mn_­name) (new_c­olu­mn_­name) (data_­type);
Show columns from a table
SHOW COLUMNS FROM (tbl_name)
Delete column
ALTER TABLE (tbl_name) DROP COLUMN (colum­n_n­ame);

Putty

Descri­ption
Shortcut
Paste into console
SHIFT+­INSERT

Linux

Descri­ption
Command
Install MariaDB
sudo apt install mariad­b-s­erver
Install Mysql Connector to Python
pip install mysql-­con­nec­tor­-py­thon-rf
Reverse Search
CTRL+R

Git

Command
Descri­ption
git add
Adds the changes to the commit
git commit -m "­MES­SAG­E"
Creates a new commit from the added changes
git push
Pushes the commit to the repository
git status
Check the diferences between the Head and the current tree

Tools

Link
Descri­ption
JSON Online Editor