Hello there, everyone!
TIL, SQL index starts with 1, not with 0. I'm really surprised at this fact, because I'm way too used to counting starting from 0 when programming. I find myself easily thrown off when mentally calculating index-related stuff in SQL, because of 1-based index. Either way, it's just something I need to take into account.
That aside, I spent most of my free time today learning string-related functions in MySQL. I didn't learn all of the functions in the MySQL string functions documentation, but I familiarized them. What I focused on were the most commonly used string functions.
Anyway, let's move on to my daily report!
I did basic CRUD practice exercises in MySQL to get more used to them.
- I learned how to utilize the most commonly used string functions in MySQL such as:
CONCAT- concatenates multiple strings together.
UPPER- converts a string to uppercase.
LOWER- converts a string to lowercase.
REVERSE- reverses the order of characters in a string.
REPLACE- takes in a string, and replaces substring with another substring.
SUBSTRING- retrieves a substring from a string, starting and ending indices can be selected.
CHAR_LENGTH- returns the number of characters in a string.
- skimmed through MySQL string functions documentation.
- continued Colt Steele's MySQL course.
- continued reading through An Introduction to the Nexus Framework.
Thank you for reading! Have a good day!
- The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert
- The 2020 Scrum Guide
- An Introduction to the Nexus Framework
This is not a guide, it is just me sharing my experiences and learnings. This post only expresses my thoughts and opinions (based on my limited knowledge) and is in no way a substitute for actual references. If I ever make a mistake or if you disagree, I would appreciate corrections in the comments!