3,491
社区成员
![](https://csdnimg.cn/release/cmsfe/public/img/topic.427195d5.png)
![](https://csdnimg.cn/release/cmsfe/public/img/me.40a70ab0.png)
![](https://csdnimg.cn/release/cmsfe/public/img/task.87b52881.png)
![](https://csdnimg.cn/release/cmsfe/public/img/share-circle.3e0b7822.png)
set SQL_STR :=CONCAT('SELECT COUNT(DISTINCT CALLERPHONE) into @T_VAR_DOWN_USERSTAT FROM ',USER_MONTH_TABLE ,' where DISCOVER_WAY =1');
CALL EXECUTE_IMMEDIATE( SQL_STR );
SET VAR_DOWN_USERSTAT=@T_VAR_DOWN_USERSTAT;
SQL_STR :='SELECT COUNT(DISTINCT CALLERPHONE) into :a ' || USER_MONTH_TABLE || ' where DISCOVER_WAY =1';
EXECUTE IMMEDIATE SQL_STR USING VAR_DOWN_USERSTAT;
SQL_STR :='SELECT COUNT(DISTINCT CALLERPHONE) into :a ' || USER_MONTH_TABLE || ' where DISCOVER_WAY =1';
EXECUTE_IMMEDIATE SQL_STR USING VAR_DOWN_USERSTAT;
话说mysql不太熟,你试试吧
PS:看不上concat,能用||就用||,其实concat应该不用改的。