Does MySQL support defining a table inside a session without appending it to the database?

As per stated in the title. Does MySQL support defining locally a table? (as a ‘local variable’ perhaps?)

I understand (according to ‘Source’) that MySQL has ‘two types of variables’: (1) local and (2) user variables, nevertheless neither can be a whole table.


Source:


EDIT: I think that using the ‘temporary’ flag in ‘create’ is the answer

CREATE (TEMPORARY) TABLE (IF NOT EXISTS) tbl_name

from the docs: https://dev.mysql.com/doc/refman/8.0/en/create-table.html