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.