MYSQL cheatsheet

Description

Based on the MySQL Cheatsheet, this reference covers essential database operations and syntax:

• MySQL Elements: Reference lists for numeric, date/time, and string/text data types, literal definitions, comment syntax, and basic arithmetic calculations.
• Database & Table Management: Commands to list databases, switch contexts, view tables, create new tables, and alter or drop table structures.
• Data Manipulation: Syntax for inserting records, updating column values, and deleting rows with condition filtering.
• Data Retrieval & Querying: Comprehensive SELECT queries utilizing filters (WHERE, BETWEEN, IN, LIKE), constraints (NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY), sorting (ORDER BY), and grouping (GROUP BY, HAVING).
• Functions: Built-in string, numeric, date/time, and aggregate functions for data transformation and analysis.
• Advanced Features: Multi-table joins (Inner, Left, Right, Full, Self), performance indexes, virtual views, atomic transactions (COMMIT, ROLLBACK), and user privilege management.