SQL

Weekly Reading for week of 01/19/2019

Enjoy the weekend with these great open-source SQL blog posts from around the web… At times, a few may be a bit dated, but worth the read, while others are relatively current… Share them along…


Advertisements

SAVEPOINT in MySQL – with examples.

DML or Data Manipulation Commands should be handled with utmost care in SQL for the simple reason they modify the targeted data in some way. Typically, this is via UPDATE or DELETE statements. In this blog post, we will learn how to better protect the data (and ourselves) when running these types of commands by utilizing a SAVEPOINT within a TRANSACTION.

[Head this way for more great MySQL blogging >>>]

Weekly Reading for Week of 01-12-2019

Enjoy the weekend with these great open-source SQL blog posts from around the web… At times, a few may be a bit dated, but worth the read, while others are relatively current… Share them along…


Using the FOUND_ROWS() function in a MySQL Stored Procedure.

In, Exploring the FOUND_ROWS() function in MySQL – First encounter…, I blogged about my initial exploration of the FOUND_ROWS() function. I also mentioned an alternative use for it in a Stored Procedure versus a SELECT COUNT(*) INTO statement, capturing a row count into a user-defined variable. This companion post will take the concept further, putting it into practice for a similar type of Stored Procedure…

[Head this way for more great MySQL blogging >>>]

Weekly Reading for weeks of 12/15/2018 and 12/22/2018.

Enjoy the weekend with these great open-source SQL blog posts from around the web… At times, a few may be a bit dated, but worth the read, while others are relatively current… Share them along…