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.

Here is a nice description.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.