Treffer: MySQL 5 Stored Procedures, Views, and Triggers.

This article looks into the application of the procedures, views, and triggers from the newly-released MySQL 5 operating system with the development and release of the MySQL 5 operating system. A simple stock trading application was developed to track price changes for a variety of common securities in an effort to demonstrate the stored procedures, views, and triggers of the MySQL 5 system. Furthermore, a stored procedure or routine is simply a container for a set of SQL statements. The next feature to add to the application is the ability to watch certain stock symbols to compare the performance of watched stocks to the average of all the stocks in the database. Moreover, triggers are used to automate the statistics in the simple stock trading application. Finally, MySQL 5 also includes a number of other improvements including stored functions, server-side cursors, and meta-database.