MySQL Notes for Professionals (GoalKicker.com) (Z-Library)

# MySQL Notes for Professionals — Reading Guide ## 【One-Line Pitch】 A practical, recipe-style reference for MySQL users who want quick answers on data types, SELECT queries, NULL handling, and CRUD operations without wading through dense documentation. Ideal for beginners needing a structured introduction and intermediate users looking for a compact refresher. ## 【Book Arc】 - **Opening (~0%–20%)**: Covers getting started with MySQL, including installation basics and Information Schema examples, then dives into data types — CHAR vs VARCHAR, numeric types (integer, fixed-point, floating-point), temporal types, and implicit casting behavior. - **Early (~20%–40%)**: Focuses on the SELECT statement in depth, walking through DISTINCT, column selection, LIKE patterns, CASE/IF logic, aliases, LIMIT, BETWEEN, WHERE clauses, and date-range filtering — the core query toolkit. - **Middle (~40%–60%)**: Addresses practical syntax details: backtick usage for identifiers, NULL semantics and testing, LIMIT/OFFSET pagination relationships, and database creation with users and grants. - **Middle (~60%–80%)**: Introduces variables in SELECT statements (including row-number patterns with GROUP BY), comment syntax for code and table definitions, and begins the INSERT chapter with upsert patterns and multi-row inserts. - **Late (~80%–100%)**: Completes INSERT coverage with AUTO_INCREMENT handling and INSERT...SELECT, then moves to DELETE operations — basic deletes, WHERE clauses, multi-table deletes, and the DELETE vs TRUNCATE distinction. ## 【Key Takeaways】 - **Data type selection matters more than it seems** (Early): CHAR(n) is fixed-length while VARCHAR(255) has overhead implications; choosing wrong types affects storage and performance. The book walks through integer, fixed-point, and floating-point trade-offs. - **Implicit casting can surprise you** (Early): MySQL automatically converts between types in many contexts, which is convenient but can produce unexpected results — worth testing edge cases in your own queries. - **SELECT is the workhorse — master its variants** (Early–Middle): DISTINCT, LIKE with % and _, BETWEEN, CASE/IF expressions, and aliases cover most real-world query needs. The book treats each as a discrete pattern you can copy. - **NULL is not zero or empty string** (Middle): Testing NULLs requires IS NULL / IS NOT NULL, not equality operators. Understanding this avoids classic query bugs. - **LIMIT and OFFSET work together for pagination** (Middle): The relationship between these two clauses is explained clearly — essential for building paged result sets correctly. - **Backticks solve identifier conflicts** (Middle): When column or table names collide with reserved words, backticks are the escape hatch — a small detail that prevents frustrating syntax errors. - **INSERT has several powerful variations** (Late): ON DUPLICATE KEY UPDATE handles upserts, INSERT...SELECT moves data between tables, and LAST_INSERT_ID() retrieves generated keys — three patterns that cover most data-loading scenarios. - **DELETE vs TRUNCATE is a real decision** (Late): TRUNCATE resets AUTO_INCREMENT and is faster but less flexible; DELETE with WHERE gives control. Multi-table deletes extend the basic pattern for relational cleanup. ## 【Reading Tips】 - **Skim the data types chapter** if you already know your CHAR from your VARCHAR — but do read the implicit casting section, as it's a common source of subtle bugs. - **Deep-read the SELECT chapter** — it's the longest and most practical section, with patterns you'll reuse daily. The LIKE and date-range sections are especially worth internalizing. - **Treat the book as a reference, not a narrative** — jump to the section matching your current task (e.g., "how do I upsert?") rather than reading cover to cover. - **Watch for the AUTO_INCREMENT discussions** across INSERT and DELETE chapters — lost IDs and LAST_INSERT_ID() behavior are frequently misunderstood in production. - **The excerpts don't cover indexes, joins, or performance tuning** — if you need those topics, this book alone won't suffice; pair it with a more advanced MySQL resource. ## 【Coverage Limits】 This guide covers the book's content on fundamentals, data types, SELECT patterns, NULL handling, and CRUD operations. The excerpts do not include material on indexing, query optimization, stored procedures, or replication — if present in the full book, those sections fall outside this guide's scope. ##