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;