Mysql Execute stmt output

Question

This is MySQL procedure. How can I receive the output into the variable?

this is an analyze statements in a loop. this return many results to the code and I would like to save those results in the log table.

result example : alonpdb.XXX analyze status OK

SET @analyze_stmt = CONCAT('ANALYZE TABLE ', @v_table_name);
PREPARE stmt FROM @analyze_stmt;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;