hello everyone ,
I'm facing a problem in inserting data in TEMPORARY table.
i can do it by simple query easily. but i want to do through
for Ex.
i have bunch of query which i'm executing through
SET @QueryText="Select ID from employees limit 5"; //it contains bunch of qury this only ex.
PREPARE Statement FROM @QueryText;
EXECUTE Statement;
and now i want to insert this data in my TEMPORARY table
i.e. CREATE TEMPORARY TABLE abcd (Id INT);
so i don't have idea how to do it.