0

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.

2
Contributors
1
Reply
2
Views
6 Years
Discussion Span
Last Post by pritaeas
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.