How to create and use temporary tables in MySQL?

The temporary tables could be very useful in some cases
to keep temporary data. The most important thing that
should be know for temporary tables is that they will
be deleted when the current client disconnects

You could try to create such a temporary table

CREATE TEMPORARY TABLE MyTemporaryTable SELECT * FROM MyRealTable WHERE id<10;