It is sometimes useful to create tables for temporary use. This can be done by using the CREATE TEMPORARY TABLE command rather than CREATE TABLE. A temporary table differs from a non- temporary table in the following ways: • It's visible only to the client (and connection) that created it and may be used only by that client (and connection). This means that different clients (even with different connections) can create temporary tables that have the same name and no conflict occurs. • A temporary table exists only for the duration of the connection in which it was created. The server drops a temporary table automatically when the client connection ends if the client has not already dropped it. • A temporary table may have the same name as a non-temporary table. The non-temporary table becomes hidden to the c...
“The best way to be ready for the future is to invent it.”— John Sculley