May 292012

The INFORMATION_SCHEMA database is where each MySQL instance stores information about all the other databases that the MySQL server maintains. Also sometimes referred to as the data dictionary and system catalog, it’s the ideal place to lookup information such as the name of a database or table, the data type of a column, or access privileges. Today’s article will provide an overview of the INFORMATION_SCHEMA database as well as some practical examples of its many uses.


 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>