requte1_film.sql

a small application in Mysql and Delphi

CREATE  PROCEDURE requte1_film( code VARCHAR(4))
BEGIN
IF code='*' THEN
SELECT * FROM FILM;
ELSE
SELECT * FROM film WHERE code_film=code;
END IF;
END/