DROP PROCEDURE IF EXISTS test;

DELIMITER //

CREATE PROCEDURE test()

BEGIN

DECLARE tablename TEXT;

DECLARE done integer default 0;

DECLARE cur Cursor FOR SELECT news_name FROM find_table_names WHERE 1;

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

OPEN cur;

WHILE done = 0 DO
FETCH cur INTO tablename;
    SELECT COUNT(*) FROM tablename;
END WHILE;

CLOSE cur;
END//

DELIMITER ;

CALL test;