Mysql Commands
MySQL =============== Getting started: - http://www.sqlteaching.com/ - https://www.codecademy.com/courses/learn-sql Related tutorials: - [MySQL-CLI](https://www.youtube.com/playlist?list=PLfdtiltiRHWEw4-kRrh1ZZy_3OcQxTn7P) - [Analyzing Business Metrics](https://www.codecademy.com/learn/sql-analyzing-business-metrics) - [SQL joins infografic](https://lh4.googleusercontent.com/-RdjzcoAwBYg/UxTXWGJHgoI/AAAAAAAACrs/Gqbu6zyksgo/w852-h670/sql-joins.jpg) Tools: - [DataGrip](https://www.jetbrains.com/datagrip/) - [Sequel Pro](http://www.sequelpro.com/) Commands ----------- Access monitor: `mysql -u [username] -p;` (will prompt for password) Show all databases: `show databases;` Access database: `mysql -u [username] -p [database]` (will prompt for password) Create new database: `create database [database];` Select database: `use [database];` Determine what database is in use: `select database();` Show all tables: `show tables;` Show table structure: `describe [table];` List al...