I would forget about using temporary tables in your database and use regular tables instead. It shouldn’t be too difficult to drop the created table at a certain point.
As mentioned earlier, it looks like temporary tables are mostly used in stored procedures or functions within mysql.