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.
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