Clarifying a common misunderstanding about MySQL LEFT JOIN: why the result count isn't always the same as the left table's count when there are multiple matching records in the right table.
Jan 26, 2021
When performing complex updates on tables with hundreds of thousands of rows, single massive transactions can cause issues. This post shares a script-based approach to breaking down updates into smaller, safer chunks.
Nov 3, 2020