Using MySql dynamic query @mySql

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.

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

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