cPanel Temporary Tables

I don't know if there is anyone here who is using cPanel for their database administration.

I have tried to reach the cPanel Community and have had password problems.

Anyway, I have built a temporary table by using MySQL code:
CREATE TEMPORARY TABLE Invoices01b SELECT * FROM Invoices01c LIMIT 0;

I do not get any error messages when I create the table but the table Invoices01b does not seem to exist when I try to use it.

Do temporary tables work in Retool?

Mike