To create a temporary table, use the following command:

where GLOBAL is supported for compatibility reasons. However, even if the keyword GLOBAL is not specified, all temporary tables are global. <...> denotes syntax that is the same as for any other type of table.

Temporary tables are always in-memory tables. If you use the STORE DISK clause, the server will give you an error. If you use STORE MEMORY, or if you omit the STORE clause altogether, the server will create the temporary table as an in-memory table.