O'Reilly logo

MySQL 5.0 Certification Study Guide by Carsten Pedersen, Stefan Hinz, Paul DuBois

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

20 Obtaining Database Metadata

Databases contain data, but information about the way databases are structured is metadata. This chapter discusses the various means by which MySQL provides access to metadata for database, tables, and other objects. It covers the following exam topics:

Image Metadata access methods

Image Using the INFORMATION_SCHEMA database to access metadata

Image Using SHOW and DESCRIBE statements to access metadata

Using the mysqlshow program ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required