MySQL™: The World’s Most Popular Open Source Database 170 5.0: Stored Procedures • ANSI SQL99, can be extended to e.g. PHP or PL/SQL • CREATE PROCEDURE MyProc (IN InputField SMALLINT, OUT OutputField SMALLINT ... • CALL MyProc(5,@MyVariable); • Grammar with BEGIN, END, SET, RETURN, CASE, IF, LOOP, WHILE, REPEAT, FOR Copyright 2003 MySQL AB