Modifying Data With SQL Cheatsheet

Adding a Row to a Table

Inserting a single row:

INSERT INTO <table> VALUES (<value 1>, <value 2>, ...);

DannyCrews / sql-reporting-cheatsheet.md

Created June 8, 2016 18:48

Ordering by a single column criteria:

SELECT * FROM <table name> ORDER BY <column> [ASC|DESC];

DannyCrews / sql-basics-cheatsheet.md

Created June 8, 2016 18:46

SELECT * FROM <table name>;

DannyCrews / git_cheatsheet.md

Last active May 9, 2016 00:48

Git command cheatsheet from Michael Hartl's Learn Enough Git to be Dangerous

Command	Description	Example
`git help`	Get help on a command	`$ git help push`
`git config`	Configure Git	`$ git config --global …`
`source <file>`	Activate Bash changes	`$ source ~/.bash_profile`
`mkdir -p`	Make intermediate directories as necessary	`$ mkdir -p repos/website`
`git status`	Show the status of the repository	`$ git status`
`touch <name>`	Create empty file	`$ touch foo`
`git add -A`	Add all files or directories to staging area	`$ git add -A`

DannyCrews / command_line_cheat_sheet.md

Last active May 9, 2016 00:48

A collection of the most useful command line commands per Michael Hartl's 'Learn Enough Command Line to be Dangerous'

Command	Description	Example
`echo <string>`	Print string to screen	`$ echo hello`
`man <command>`	Display manual page for command	`$ man echo`
`⌃C`	Get out of trouble	`$ tail^C`
`⌃A`	Move to beginning of line
`⌃E`	Move to end of line
`⌃U`	Delete to beginning of line
`Option-click`	Move cursor to location clicked

DannyCrews / curl.md

Created February 10, 2014 03:48 — forked from btoone/curl.md

An introduction to curl using GitHub's API

Makes a basic GET request to the specifed URI

curl https://api.github.com/users/caspyin

DannyCrews / Contract Killer 3.md

Created January 30, 2014 18:19