MySQL® Notes for Professionals


Chapters

  1. Getting started with MySQL
  2. Data Types
  3. SELECT
  4. Backticks
  5. NULL
  6. Limit and Offset
  7. Creating databases
  8. Using Variables
  9. Comment MySQL
  10. INSERT
  11. DELETE
  12. UPDATE
  13. ORDER BY
  14. Group By
  15. Error 1055: ONLY_FULL_GROUP_BY: something is not in GROUP BY clause …
  16. Joins
  17. JOINS: Join 3 table with the same name of id.
  18. UNION
  19. Arithmetic
  20. String operations
  21. Date and Time Operations
  22. Handling Time Zones
  23. Regular Expressions
  24. VIEW
  25. Table Creation
  26. ALTER TABLE
  27. Drop Table
  28. MySQL LOCK TABLE
  29. Error codes
  30. Stored routines (procedures and functions)
  31. Indexes and Keys
  32. Full-Text search
  33. PREPARE Statements
  34. JSON
  35. Extract values from JSON type
  36. MySQL Admin
  37. TRIGGERS
  1. Configuration and tuning
  2. Events
  3. ENUM
  4. Install Mysql container with Docker-Compose
  5. Character Sets and Collations
  6. MyISAM Engine
  7. Converting from MyISAM to InnoDB
  8. Transaction
  9. Log files
  10. Clustering
  11. Partitioning
  12. Replication
  13. Backup using mysqldump
  14. mysqlimport
  15. LOAD DATA INFILE
  16. MySQL Unions
  17. MySQL client
  18. Temporary Tables
  19. Customize PS1
  20. Dealing with sparse or missing data
  21. Connecting with UTF-8 Using Various Programming language.
  22. Time with subsecond precision
  23. One to Many
  24. Server Information
  25. SSL Connection Setup
  26. Create New User
  27. Security via GRANTs
  28. Change Password
  29. Recover and reset the default root password for MySQL 5.7+
  30. Recover from lost root password
  31. MySQL Performance Tips
  32. Performance Tuning
  33. Reserved Words

Credits
Thank you greatly to all the people from Stack Overflow Documentation who helped provide this content, more changes can be sent to web@petercv.com for new content to be published or updated. (See page 187 to watch all creedit over PDF file, please).


Source: goalkicker.com/MySQLBook

Click to rate this post
[Total: 0 Average: 0]