In Part 1 we looked at using VIEWS to keep our SQL DRY. Unfortunately, there are cases when VIEWS are either not allowed or perform terribly and can’t be optimised. Stored Procedures are, of course, the mainstay of writing DRY SQL, and optimisation. Unfortunately, you can’t treat the result set of Stored Procedure as a query; therefore you can’t join storedContinue reading “How to write DRY SQL in MySQL – Part 2: Stored Procedure Hacks”
Reflections 