illydali/learning_mysql

Use SqlDBM.com for logical diagram

To import in a database - eg Chinook

mysql -u root < chinook.sql

Logging in via the terminal

For Gitpod, PC

mysql -u root

For MacOS

mysql -u root -p

SQL Commands

• Remember need semicolon - ; at the end of every command!
• Commands are case insensitive

1. DDL - Data Definition Language
2. Data Query language