SELECT table_name FROM INFORMATION_SCHEMA.TABLES
WHERE table_schema = 'db_name' 

##</code><code>##

$sql = join ' UNION ', map "SELECT ID, Name, Class, Mark, $_  table_name from $_", @tables;