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
- 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
MySQL Error codes
30% OFF - 9th Anniversary discount on Entity Framework Extensions until December 15 with code: ZZZANNIVERSARY9
Error codes Related Examples
- 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
