O'Reilly Open Source Convention - August 1-5, 2005

Session
Flagship Features in MySQL 5.0
Trudy Pelzer, Project Engineering Manager, MySQL AB

Track: Databases
Date: Thursday, August 4th, 2005
Time: 4:30pm - 5:15pm
Location: D136
Views, stored procedures, and triggers have long been considered a basic requirement of an enterprise-ready DBMS. Now, MySQL 5.0 introduces support for these flagship features, as well as for a standard SQL-compliant INFORMATION_SCHEMA data dictionary, bringing the popular open-source DBMS several steps closer to matching all the capabilities of the competition.

This presentation provides a brief overview of MySQL's implementation of views, stored procedures, triggers, and INFORMATION_SCHEMA, with special emphasis on the extensions to the standard SQL requirements which have been added. Topics include:

- View Concepts:
Why are views important?
View syntax (creating, dropping, using views)
Privileges: who can create a view, who can use a view?
- Stored Procedures Concepts:
Stored procedure syntax (creating, dropping, using stored procedures)
Using cursors in a stored procedure
- Triggers Concepts:
Trigger syntax (creating, dropping, using triggers)
- INFORMATION_SCHEMA Concepts:
What does INFORMATION_SCHEMA do for me?
How to access your metadata

Download presentation file