Published at LXer:

I originally planned on writing an article over Common Table Expressions (CTEs) but since MySQL does not currently support CTEs, and there has been much debate as to why they should implement it, I decided not to write an article about it. MySQLs answer to CTEs is Temporary Tables. A temporary table is a base table that is not stored in the databse, but instead exists only while the database session in which it was created is active. In this article we will look further at what a Temporary Table is, how to use them and when it is appropriate to use them.

Read More...