Grand Tour of the Information Schema and its Applications
Presented at the 2009 MySQL Camp:
Grand Tour of the Information Schema and its Applications
by Roland Bouman
Description:
The following topics will be covered:
Introduction of the information schema and its components
How to generate WIKI documentation from the information schema
Generating code (triggers, SPs) to maintain a rich history database
Creating a stored procedure to check violated foreign key constraints
Creating a stored procedure to create federated tables