MySQL

• Getting started with MySQL
• 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
• Error 1055: ONLY_FULL_GROUP_BY: something is not in GROUP BY clause ...
• Error codes
• 1045 Access denied
• 1067, 1292, 1366, 1411 - Bad Value for number, date, default, etc.
• 1236 "impossible position" in Replication
• 126, 1054, 1146, 1062, 24
• 126, 127, 134, 144, 145
• 1366
• 139
• 2002, 2003 Cannot connect
• Error code 1064: Syntax error
• Error code 1175: Safe Update
• Error code 1215: Cannot add foreign key constraint
• 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
• Stored routines (procedures and functions)
• String operations
• Table Creation
• Temporary Tables
• Time with subsecond precision
• Transaction
• TRIGGERS
• UNION
• UPDATE
• Using Variables
• VIEW