What are MySQL Temporary Tables?

Posted by kprojects on Jun 15, 2012 2:24 AM EDT
Linux.org; By Ronald Steelman
Mail this story
Print this story

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.

Full Story

» Read more about: Groups: MySQL

« Return to the newswire homepage

This topic does not have any threads posted yet!

You cannot post until you login.