MySQL

• Getting started with MySQL
• Awesome Book
• Awesome Community
• Awesome Course
• Awesome Tutorial
• Awesome YouTube
• ALTER TABLE
• Arithmetic
• Backticks
• Backup using mysqldump
• Change Password
• Character Sets and Collations
• Clustering
• Comment Mysql
• Configuration and tuning
• Connecting with UTF-8 Using Various Programming language.
• Converting from MyISAM to InnoDB
• Create New User
• Creating databases
• Customize PS1
• Data Types
• Date and Time Operations
• Dealing with sparse or missing data
• DELETE
• Drop Table
• Dynamic Un-Pivot Table using Prepared Statement
• ENUM
• Adding a new option
• NULL vs NOT NULL
• TINYINT as an alternative
• VARCHAR as an alternative
• Why ENUM?
• Error 1055: ONLY_FULL_GROUP_BY: something is not in GROUP BY clause ...
• Error codes
• Events
• Extract values from JSON type
• Full-Text search
• Group By
• Handling Time Zones
• Indexes and Keys
• INSERT
• Install Mysql container with Docker-Compose
• Joins
• JOINS: Join 3 table with the same name of id.
• JSON
• Limit and Offset
• LOAD DATA INFILE
• Log files
• Many-to-many Mapping table
• MyISAM Engine
• MySQL Admin
• MySQL client
• MySQL LOCK TABLE
• Mysql Performance Tips
• MySQL Unions
• mysqlimport
• NULL
• One to Many
• ORDER BY
• Partitioning
• Performance Tuning
• Pivot queries
• PREPARE Statements
• Recover and reset the default root password for MySQL 5.7+
• Recover from lost root password
• Regular Expressions
• Replication
• Reserved Words
• Security via GRANTs
• SELECT
• Server Information
• SSL Connection Setup