3 ms·
One specific thing I like to bash about MySQL is that it doesn't support CTEs (aka: with-statements) which are part of the 1999 SQL standard (nearly 20 years ol
by Buttons840 10y ago
One specific thing I like to bash about MySQL is that it doesn't support CTEs (aka: with-statements) which are part of the 1999 SQL standard (nearly 20 years old now). I miss them frequently when working with MySQL.
- rwultsch 10y agoPostgres has had CTE for a while, but not that long. MySQL 8.0 (the next version) plans to them http://mysqlserverteam.com/mysql-8-0-labs-recursive-common-table-expressions-in-mysql-ctes/ http://mysqlserverteam.com/mysql-8-0-labs-recursive-common-t...