Conmanly Used MySql Commands
| Command | Description |
|---|---|
| CREATE DATABASE [database_name]; | Create a database |
| SHOW DATABASES; | List all databases |
| USE [database_name]; | Switch to a database |
| SHOW TABLES; | List all the tables in the database |
| DESCRIBE [table_name]; | List all field in database |
| DROP DATABASE [database_name]; | Delete database |
| DROP TABLE [table_name]; | Delete table |