DDL: Database Definition language
Primarily used to define databases, tables, views, indexes, triggers, and more
Create: Primarily for creating databases, creating tables, and creating views
Alter: Primarily used to modify the definition of a table, modify the definition of a view
Drop: Primarily used to delete databases, delete tables, and views
DML: Data Manipulation language
Used primarily for inserting data, querying data, updating data, and deleting data
Insert: for inserting data
Select: For querying data
Update: for updating data
Delete: Used to delete data
DCL: Data Control Language
Primarily used to control the user's access rights
Grant: Used to add permissions to a user
Revoke: Permission to reclaim a user
MySQL Date and Time type
Integer type 0 value
Year 0000
Date 0000:00:00
Time 00:00:00
DateTime 0000-00-00 00:00:00
Timestamp 00000000000000 Note: The range of values is not a datetime large
Enum type
Attribute name enum (' Value ', ' value ', ' Value n ')
MySQL additions and deletions (supplemental)