0
greetings! My question is the following: I would like to know how to create a temporary table within a procedure, in which the values of my temporary table will be taken from a permanent table in my database. From the permanent table I will only need to use two columns to validate my procedure. And after the execution of the procedure exclude this temporary table.
"how do I create a temporary table within a procedure" using the command
CREATE TEMPORARY TABLE, as if it were a common table– Ricardo Pontual
But as I call into the columns that will be in the temporary table the data of the other two columns of the permanent table?
– Felipe Vieira
your question is confused, the problem is create table or insert data? to insert use
INSERT INTOwith select in the other table, or easierSELECT INTO– Ricardo Pontual
The biggest problem is to insert this data from another table.
– Felipe Vieira