# for mysql temporary table (exists until end of session)
CREATE TEMPORARY TABLE table_name(
  ...
);