Database Transactions and Locking in MySQL: Avoiding Race Conditions
A practical guide to transactions, SELECT FOR UPDATE and optimistic locking for data that must stay correct under concurrency.
SQL Window Functions in MySQL 8: Running Totals, Rankings and Top-N per Group
Stop exporting to spreadsheets. MySQL 8 window functions handle running totals, rankings and month-over-month growth in one readable query.