Putting the MySQL information_schema to Use

Putting the MySQL information_schema to Use

The MySQL information schema database was introduced in the September issue of the newsletter. We’ve seen that the information schema allows us to access metadata in a much more flexible way than the MySQL specific SHOW commands. We owe this to the fact that the information schema allows us to query and format metadata using arbitrary SELECT statements. Let’s explore this feature, and try to put that to good use