Skip to main content

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);
?>
Labels:

Comments

Post a Comment

Popular posts from this blog

PHP INTRODUCTION

                     PHP  (recursive acronym for  PHP: Hypertext Preprocessor ) is a widely-used open source general-purpose scripting language that is especially suited for web development and can be embedded into HTML. PHP stands for  P HP:  H ypertext  P reprocessor PHP is a server-side scripting language, like ASP PHP scripts are executed on the server PHP supports many databases (MySQL, Informix, Oracle, Sybase, Solid, PostgreSQL, Generic ODBC, etc.) PHP is an open source software PHP is free to download and use Why PHP? PHP runs on different platforms (Windows, Linux, Unix, etc.) PHP is compatible with almost all servers used today (Apache, IIS, etc.) PHP is FREE to download from the official PHP resource:  www.php.net PHP is easy to learn and runs efficiently on the server side What can PHP do? Anything. PHP is mainly focused on server-side scripting, so you can...
6 comments
Read more

Storage Engine Breakdown

The following diagram represents a simplified view of the MySQL server and its interaction with the  storage engines. The following properties are storage engine dependant: • Storage Medium – Each table uses its own method of storing the data it contains. • Transactional Capabilities – Certain storage engines handle transactional processing which ensures that integrity of a database is maintained during the processing of multiple SQL statements.
Post a Comment
Read more

Managing Database Tables

1. Login in to the mysql client using the login name and password provided by your instructor. 2. View the existing databases that the MySQL Server is maintaining. SHOW DATABASES; 3. Utilize the photo_album database. USE photo_album; 4. Create the first table called customers that will store the information related to the customers who have purchased access to the online photo album CREATE TABLE customers ( email_customer VARCHAR(50) NOT NULL DEFAULT '', f_name VARCHAR(20) NOT NULL DEFAULT '', l_name VARCHAR(30) NOT NULL DEFAULT '', addr1 VARCHAR(30) NOT NULL DEFAULT '', addr2 VARCHAR(30) NULL, addr_city VARCHAR(25) NOT NULL DEFAULT '', addr_state CHAR(3) NOT NULL DEFAULT '', addr_zip CHAR(10) NOT NULL DEFAULT '', primary_phone CHAR(12) NOT NULL DEFAULT '', secondary_phone CHAR(12) NULL, term_date DATE NOT NULL DEFAULT 0, active_customer ENUM('True', 'False') NOT NULL DEFAULT ...
Post a Comment
Read more