Underlying Principles of MySQL Join Queries
BytePilot 1. Overview of Join Algorithms MySQL relies on three core algorithms to execute join queries: 1.1 Nested-Loop Join Basic principle: Use the left table as the driving table, iterate through…
Database & Persistence
MySQL transaction isolation levels: Read Uncommitted, Read Committed, Repeatable Read, and Serializable
What are Transaction Isolation Levels? When multiple transactions are executed concurrently, problems may arise if they are not isolated. These include dirty reads, non-repeatable reads, and phantom reads. Transaction isolation…
MySQL Index Types and Related Operations
I. Introduction Currently, MySQL mainly has the following index types: II. Statements III. Index Types 1. Normal Index It is the most basic index with no restrictions. It can be…
MySQL Basic Operations Guide
I. MySQL Connection & Disconnection 1. Connect to Local Database 2. Connect to Remote Database 3. Exit Database II. Database Operations 1. View All Databases 2. Create Database 3. Switch…