Skip to content
Tagged articles

correlated subquery

3 articles · Page 1 of 1
Linux Tech Enthusiast
Linux Tech Enthusiast
Sep 28, 2026 · Databases

8 SQL Anti-Patterns That Kill Performance (and How to Fix Them)

This article details eight common SQL anti-patterns — including OFFSET pagination, implicit type conversion, correlated subqueries in updates, mixed sorting, EXISTS clauses, blocked condition pushdown, late filtering, and unoptimized intermediate results — with execution plans and rewrites that reduce query times from seconds to milliseconds.

CTEPaginationQuery Performance
0 likes · 16 min read
8 SQL Anti-Patterns That Kill Performance (and How to Fix Them)
Tech Musings
Tech Musings
Sep 7, 2026 · Databases

MySQL Subquery Column Name Escaping: Silent Full-Table Update/Delete Risk

MySQL silently resolves missing column names in subqueries to outer scope columns, turning filters into correlated subqueries that always evaluate true, causing full-table updates or deletes without errors or warnings; no sql_mode prevents this behavior.

Best Practicescolumn resolutioncorrelated subquery
0 likes · 10 min read
MySQL Subquery Column Name Escaping: Silent Full-Table Update/Delete Risk