Usually, we say query statement as a whole, but I don’t understand exactly what are the differences and features of DDL, DML, DCL, and TCL, so I’m going to summarize them in this post.
When using MySQL databases, you can optimize performance by tuning various system variables. Among them, the range_optimizer_max_mem_size
setting is one important variable that can have a big impact on optimizing query performance. In this post, we’ll learn more about what range_optimizer_max_mem_size
is and when you should adjust it.
When writing queries, we sometimes run into situations where we need to use multiple JOIN statements. This can lead to poor readability. Utilizing a Common Table Expression (CTE) can help make your queries more readable.
I recently moved to a different company and I got to use MYSQL and got paid for it as a list, but I checked and found out that MYSQL itself doesn’t have an ARRAY type, so I’d like to organize it simply.