Dynamic SQL

Dynamic SQL generates and executes SQL statements dynamically during runtime.

SET @query = 'SELECT * FROM ' + table_name;
PREPARE stmt FROM @query;
EXECUTE stmt;