The distinction between SQL, TSQL, and PL/SQL is a question that regularly arises while teaching data platform courses because these terminologies are used frequently in
INSERT the key into multiple tables in MySQL
Foreign key relationships may occasionally need to be inserted at the same time as the primary key. We won’t know what the primary key will
Last Insert ID in MySQL
LAST_INSERT_ID() function return the AUTO_INCREMENT id of the last row that has been inserted or updated in a table. Here is an example. DROP TABLE
While Loop in MySQL Stored Procedure
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,
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
Big Data and SQL 