How to create and use temporary tables in MySQL?

By: Guest
Date: Fri-May-22-2009-
Response
3
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;

[d] By: Guest
Date: Fri-May-22-2009
Response
What is 1 + 100

Just Updated::