Trudy Pelzer, Project Engineering Manager, MySQL AB
Date: Thursday, August 4th, 2005
Time: 4:30pm - 5:15pm
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