Fiddling with MySQL: information_scheme

Fiddling with MySQL: information_scheme

$check_tables = array(
            'table_1', 'table_2', 'table_3'
        );

        $check_tables_strs = array_map(function($n){
            return "SELECT '{$n}' as table_name";
        }, $check_tables);

        $unions = implode($check_tables_strs, " UNION ALL \n");

        $information_scheme_query = <<<IBQ
SELECT
tn.table_name, t.table_rows, t.data_length,
DATE_FORMAT(t.update_time, '{$date_format}') AS update_time_visible, t.update_time
FROM (
{$unions}
) tn LEFT JOIN
     information_schema.tables t
     ON tn.table_name = t.table_name;
IBQ;