set @suffix := (SELECT DATE_FORMAT(now(), '%Y_%m_%d')); SET @x := CONCAT('select * from alarm_',@suffix) ; Prepare stmt FROM @x; Execute stmt;
set @suffix := (SELECT DATE_FORMAT(now(), '%Y_%m_%d')); SET @x := CONCAT('select * from alarm_',@suffix) ; Prepare stmt FROM @x; Execute stmt;