requte1_film.sql

来自「a small application in Mysql and Delphi」· SQL 代码 · 共 9 行

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/