requte1_media.sql

a small application in Mysql and Delphi

CREATE  PROCEDURE requte1_media( code VARCHAR(4))
BEGIN
IF code='*' THEN
SELECT * FROM   media ;
ELSE
SELECT * FROM  media WHERE code_media=code ;
END IF;
END/