-- 定义变量
SET @table_name = 'cdm_diabetes_risk_assessment';
-- 构建动态SQL查询字符串
SET @sql = CONCAT('SELECT * FROM ', @table_name);
-- 执行动态SQL查询
PREPARE statement FROM @sql;
EXECUTE statement;
DEALLOCATE PREPARE statement;
-- 定义变量
SET @table_name = 'cdm_diabetes_risk_assessment';
-- 构建动态SQL查询字符串
SET @sql = CONCAT('SELECT * FROM ', @table_name);
-- 执行动态SQL查询
PREPARE statement FROM @sql;
EXECUTE statement;
DEALLOCATE PREPARE statement;
Metabase does currently not support multiple statements in a query, but there are some possible workarounds for MySQL/MariaDB: