• Query: SELECT
• Filter: WHERE, AND, OR, BETWEEN, ORDER BY, GROUP BY
• JOIN: INNER, LEFT, RIGHT, FULL
• Crud data: INSERT, UPDATE, DELETE,..
• Create DB: CREATE DATABASE, CREATE TABLE, ALTER TABLE, PRIMARY KEY, CONSTRAINT,..

• Function: String, Numeric, Date/Time
• Views
• Store procedure
• Event
• Trigger
• MySQL workbench
• Backup & recovery
• Export & import data
• MySQL Indexing for performance | | Output | - cmd to connect, import, export, CRUD DB, CRUD record,...
• doc |

Intro

Create DB

Create table

Alter table

CRUD Data

Query, Filter, Join

View

Procedure

Function

Trigger

Command line

Export & Import