#mysql
Read more stories on Hashnode
Articles with this tag
Many believe MySQL’s "UTF-8" supports all Unicode characters, but that’s not the whole story. MySQL’s utf8 can only store characters up to 3 bytes,...
MySQL character sets and collations affect how text is stored and displayed in databases. This article breaks down their roles, explains key concepts,...
NULL is a special marker in databases indicating a "missing value." While it may seem simple, it introduces unique challenges in queries, indexes, and...
String manipulation is a common requirement in database management. MySQL’s SUBSTRING_INDEX function simplifies these tasks by letting you extract...
Indexes are one of the cornerstones of MySQL optimization, providing faster query performance and efficient data retrieval. However, duplicate indexes...
Certain words in MySQL, like SELECT and SHOW, are reserved for database operations, leading to potential errors if misused. Here's a brief overview of...
