How can you insert data from a stored procedure into a table?
I want to do something like this:
INSERT INTO test
CALL test30day(NOW() - INTERVAL 30 DAY, NOW());
Asked
Active
Viewed 75 times
3
-
Check this : http://stackoverflow.com/questions/662049/dynamic-sql-results-into-temp-table-in-sql-stored-procedure/15438582#15438582 – Saagar Elias Jacky May 05 '15 at 21:44
-
that's mssql. I know how to do that :) – clarity May 05 '15 at 21:47
-
I don't think it is supported in MySQL. – Uueerdo May 05 '15 at 21:56
-
Thanks. I asked in #mysql on irc.freenode.net, and they told me the same thing – clarity May 05 '15 at 22:13
-
You could include the INSERT inside the procedure; and if you wanted to use it against different tables, have the table name as a parameter and build the insert as a PREPAREd statement. – Uueerdo May 05 '15 at 22:32