class="PHP CSS HTML SQL jQuery Zend Doctrine"

Category: sql

MySQL stored programs: functions

Since the fifth release of MySQL (5.1 to be exact) programmers have capability to use stored programs (functions, procedures and triggers), a feature well known from other popular databases. According to the result of my small research it's a nameless subset of the ANSI SQL: 2003 SQL/PSM specification, very similar to the SQL PL (based on the same specification) used by DB2 and less similar to the PL/SQL (Oracle, DB2), PL/pgSQL (PostgreSQL) and T-SQL(SQL Server and Sybase).
Read more!


Back to Top