Viewing MySQL Metadata

The INFORMATION_SCHEMA is a virtual database that is automatically created and populated by
MySQL, there is no need to create an INFORMATION_SCHEMA database. There also is no associated
file structure due to the fact that the contents of the data are actual views, rather than logical data being
stored in any one location. Only SELECT statements are allowed against the tables in the
INFORMATION_SCHEMA database. The following SELECT example demonstrates some of the
metadata that can be viewed:

<?php
// Load variables used in mysql_connect and connect to server
include "connect_info.php";
$linkID1 = mysql_connect($dbhost,$dbuser,$dbpass) or
die("Could not connect to MySQL server");
// Execute Query to Collect Metadata
$query = "SELECT TABLE_NAME, ENGINE, TABLE_ROWS, UPDATE_TIME FROM
INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='world'";
$results = mysql_query($query, $linkID1);
// Build HTML Table of Results
print "<table width='700' border='1'>\n";
print "<tr>\n<th>TABLE_NAME</th>\n<th>ENGINE</th>\n";
print "<th>TABLE_ROWS</th>\n<th>UPDATE_TIME</th>\n</tr>\n";
while ($row = mysql_fetch_array($results, MYSQL_BOTH)) {
print "<tr>\n<th>".$row[0]."</th>\n<th>".$row[1]."</th>\n";
print "<th>".$row[2]."</th>\n<th>".$row[3]."</th>\n</tr>\n ";
}
print "</table>";
// Close the connection to the MySQL server
mysql_close($linkID1);
?>