Temporary Tables

Example:

create temporary table salessummary (
   -> product_name varchar(50) not null,
   -> total_sales decimal(12,2) not null default 0.00
);

Insert some data and select the same.

Now log out of the session or log back in. Try to select the data. You will see there is no such table or data.