• MySQL 5 Stored Functions and C...

Treffer: MySQL 5 Stored Functions and Cursors.

Title:
MySQL 5 Stored Functions and Cursors.
Authors:
Kruckenberg, Michael, Pipes, Jay
Source:
Linux Magazine. Feb2006, Vol. 8 Issue 2, p32-36. 5p. 6 Diagrams.
Subject Terms:
SQL, Programming languages, Electronic data processing, Open source software, Computer software, Computer systems, Stocks (Finance), Computer software industry, Computer service industry
Database:
Supplemental Index

Weitere Informationen

The article highlights one of the features of MySQL 5 computer software. This feature laid the foundation of a stock tracking application by using stored procedures, views, and triggers. It also implemented a stored procedure to encapsulate inserts into a stock tracking table. The software further created a view to generate a stock report, and added a trigger to calculate stock price history averages over time. And MySQL 5 includes support for stored functions, or sets of structured query language statements that encapsulate small operations.