Using MySql dynamic query @mySql

Get Help
1

Hi Team,
We are trying to use dynamic query for one report in metabase
Ex :
SET @sql = 'My Dynamic' + 'Query';
SELECT @sql;

But getitng following error
"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT @sql' at line 3 "

Please help.
Thanks

2

Hi @mnamdeo
The error is coming from your database.
Metabase does not support multi-statement queries:
https://github.com/metabase/metabase/issues/4050 - upvote by clicking :+1: on the first post

3

Thank you so much for your pormpt response @flamber . Appriciate it.