Day 96 of 100 Days of Code & Scrum: Stringed Along by MySQL

This content originally appeared on DEV Community and was authored by Rammina

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!

Yesterday

I did basic CRUD practice exercises in MySQL to get more used to them.

Today

MySQL

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.

Scrum

continued reading through An Introduction to the Nexus Framework.

Thank you for reading! Have a good day!

Resources/Recommended Readings

DISCLAIMER

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!

Other Media

Feel free to reach out to me in other media!

This content originally appeared on DEV Community and was authored by Rammina

Print Share Comment Cite Upload Translate Updates

APA

Rammina | Sciencx (2022-02-11T12:19:32+00:00) Day 96 of 100 Days of Code & Scrum: Stringed Along by MySQL. Retrieved from https://www.scien.cx/2022/02/11/day-96-of-100-days-of-code-scrum-stringed-along-by-mysql/

MLA

" » Day 96 of 100 Days of Code & Scrum: Stringed Along by MySQL." Rammina | Sciencx - Friday February 11, 2022, https://www.scien.cx/2022/02/11/day-96-of-100-days-of-code-scrum-stringed-along-by-mysql/

HARVARD

Rammina | Sciencx Friday February 11, 2022 » Day 96 of 100 Days of Code & Scrum: Stringed Along by MySQL., viewed ,<https://www.scien.cx/2022/02/11/day-96-of-100-days-of-code-scrum-stringed-along-by-mysql/>

VANCOUVER

Rammina | Sciencx - » Day 96 of 100 Days of Code & Scrum: Stringed Along by MySQL. [Internet]. [Accessed ]. Available from: https://www.scien.cx/2022/02/11/day-96-of-100-days-of-code-scrum-stringed-along-by-mysql/

CHICAGO

" » Day 96 of 100 Days of Code & Scrum: Stringed Along by MySQL." Rammina | Sciencx - Accessed . https://www.scien.cx/2022/02/11/day-96-of-100-days-of-code-scrum-stringed-along-by-mysql/

IEEE

" » Day 96 of 100 Days of Code & Scrum: Stringed Along by MySQL." Rammina | Sciencx [Online]. Available: https://www.scien.cx/2022/02/11/day-96-of-100-days-of-code-scrum-stringed-along-by-mysql/. [Accessed: ]

rf:citation

» Day 96 of 100 Days of Code & Scrum: Stringed Along by MySQL | Rammina | Sciencx | https://www.scien.cx/2022/02/11/day-96-of-100-days-of-code-scrum-stringed-along-by-mysql/ |

Please log in to upload a file.

There are no updates yet.
Click the Upload button above to add an update.

You must be logged in to translate posts. Please log in or register.