mysql 变量作表名查询_MySQL数据库在众多表中对表名的查询及预处理存储过程(变量做表名)...

BEGIN

#Routine body goes here...

DECLARE ad_id INT;

DECLARE _done INT DEFAULT 0;

DECLARE ad_click INT DEFAULT 0;

DECLARE ad_open INT DEFAULT 0;#ip

DECLARE ad_reg INT DEFAULT 0;

DECLARE today INT;

DECLARE _cur CURSOR FOR

SELECT id FROM 027game.games_ad;

DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET _done = 1;

OPEN _cur;

REPEAT

FETCH _cur INTO ad_id;

IF NOT _done THEN

#查询id_click

SET @tmp_tablename = CONCAT('ad_flow.',ad_id,'_click');

SET @tmp_sql = CONCAT("SELECT COUNT(id) INTO @tmp_count1 FROM ",@tmp_tablename);

PREPARE stmt FROM @tmp_sql;

EXECUTE stmt;

DEALLOCATE PREPARE stmt;

SET ad_click = @tmp_count1;

#查询id_open

SET @tmp_tablename = CONCAT('ad_flow.',ad_