I have a stored procedure that creates a temporary table.
I need to generate that table before the real query starts but i'm unable to do two queries in one question. Any solutions for this? This just generates an error message urging me to read the manual that corresponds to my MariaDB server version for the right syntax to use.
CALL GenerateMyTemporaryTable(); SELECT * FROM TemporaryTable;