2 ms·
Mysql has had subqueries since version 4.1, circa 2004!
by kristianp 15y ago
Mysql has had subqueries since version 4.1, circa 2004!
- mst 15y agoBut the optimiser is really bad at doing sensible things with them. Worse still, subqueries in the FROM clause are (documented to be) implemented as an unindexed temp table. Google apparently compiles subquery support out of their mysql instances so people don't mistakenly think they're usable.