The syntax for 'create table' in mysql is as follows...
CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name xxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxx represents other options.
So, to create temporary table, use keyword TEMPORARY. Such table will be visible only in your current database session and it will be automatically deleted when your connection is closed.