Let's take an example of a query to better understand how indexes work and how they can help. We take a simple Payment table which saves a timestamp o…
What is a Database Index?
Quoting wikipedia :
"A database index is a data structure that improves the speed of data retrieval operations on a databa…
brew install firstname.lastname@example.org
echo 'export PATH="/email@example.com/bin:$PATH"' >> ~/.zshrc && source ~/.zshrc
If you've ever wanted to learn how to write a MySQL cursor or a MySQL loop, you've come to the right place. Let's iterate!
Consider loops in general p…
1. Create an EC2 instance
Creating an EC2 instance on AWS is very easy. You can follow the instruction on this website here or AWS document.
2. Run …
MySQL is an Open Source Relational SQL database management system.