Session Flagship Features in MySQL 5.0 Trudy Pelzer Track: General Date: Tuesday, April 19 Time: 11:20am - 12:05pm Location: Ballroom E TrackBack 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 * Other Changes: Precision math: now 1/.1 is always 10 Strict error checking: how to make MySQL reject invalid data Download presentation file

Diamond Sponsor

Platinum Sponsors

Gold Sponsors

Silver Sponsors

Media Sponsors

MySQL User Conference Sponsor Opportunities — Reach business leaders and technology influencers at the MySQL User Conference. Download Exhibitor and Sponsor Prospectus. Call Andrew Calvo at 707-829-0515 or email at

Press and Media

For media-related inquiries, contact Suzanne Axtell at

Media Center — Press releases, news, and information for the press.

Conference News