This is merely to show newcomers how to create a while loop within a stored procedure. Because the while loop requires BEGIN and END statements,
Category: MySQL
AWS Aurora vs AWS MySQL
The distributed relational database service known as Amazon Relational Database Service is provided by Amazon Web Services. It is a web service that runs “in
MySQL – Find unused indexes
Indexes are used to quickly locate records with particular column values. Without an index, MySQL has to read through the entire table starting with the
MySQL Rollback Changes
All user activity in InnoDB takes place within a transaction. Each SQL query produces its own transaction when the auto-commit mode is enabled. Every time
Unknown system variable ‘query_cache_size’
You should be aware that the message while using MySQL RDS instance “Unknown system variable ‘query_cache_size‘” is not a result of an error but rather
AWS RDS – Tablespaces
The actual data that underlies database objects can be stored in a tablespace. It serves to allot storage for all DBMS-managed segments and offers a
Big Data & SQL 