How to use "Set @num := 0" in mysql

Get Help
1

I wanna to customize the variable like below via mysql in Metabase:

set @num : = 100;
select @num

It seems metabse can’t support to give the value like this via “set”

2

Hi @ScugZd
That is currently not supported.
https://github.com/metabase/metabase/issues/4050 - upvote by clicking :+1: on the first post