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

31 The INFORMATION_SCHEMA Database

The INFORMATION_SCHEMA database provides access to database metadata. This chapter discusses why you might choose to use (or not use) INFORMATION_SCHEMA in comparison to SHOW statements, which also provide metadata. The chapter covers the following exam topics:

Image Syntax for accessing INFORMATION_SCHEMA

Image Using INFORMATION_SCHEMA compared to using SHOW statements

Image Limitations of INFORMATION_SCHEMA

Chapter 20, “Obtaining ...

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