HomeProjectsArticlesNotesAbout

MySQL Notes

sql
notes

MySql

Goals

  1. clearly understand the relationship between
    • [] goal 1
    • [] goal 2
    • [] goal 3

Installation

Uppon download of dng mySQL shell and mySQL utilities expose mysql/bin to shell of choise

Example:

mySQL shell path and mySQL utilities path on system

usr/local/mysql/bin && usr/local/mysql-shell/bin

navigate to shell profiles .bashrc, .bash_profile or .zshrc add

export PATH=${PATH}:/usr/local/mysql-shell/bin
export PATH=${PATH}:/usr/local/mysql/bin

Open terminal of choice

mysql -u user-name -p

enter:

prompt for password

Sucess, we have entered the mysql shell

> shell mysql show databases;
//shows list of db's in current server
primary-key point_
sub-key point

Key Term: Description of key term

sub point

Example: Flipping a fair coin. Given:

  • There exist only two possible outcomes 'heads' 'tails'
  • Each outcome is equally likely. (Implied implicitly by the term fair) (Cite)

Defintions

Term

  • Definition:
  • Example:
  • link to wiki:
  • cite of term in source:
  • cite of term in doc:

Term

  • Definition
  • Example
  • link to wiki
  • cite of term in source
  • cite of term in doc

Resources and Reference

Notes within this doc have been drawn from the following sources:

  • source: MySQL shell CheatSheet
  • source: Source Title
    • link:
  • source: Example of literal cite
    • Sheldon Ross M(2010). A first course in probability/ Sheldon Ross. - 8th ed. Upper Saddle River, NJ: Pearson Prentice Hall

Document Details

date initialized: November,25,1017 passes to date: 1 current pass: subject:

More Articles

All Articles

Links

Home Articles Notes Projects About Style Guide Site Credits

Contact

ย connect@dev.lucaszapico.space

Location

๐ŸŒŽ Earth