sakila
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
film_not_in_stock
Parameters
Name
Type
Mode
p_film_id
int(11)
IN
p_store_id
int(11)
IN
p_film_count
int(11)
OUT
Definition
BEGIN SELECT inventory_id FROM inventory WHERE film_id = p_film_id AND store_id = p_store_id AND NOT inventory_in_stock(inventory_id); SELECT COUNT(*) FROM inventory WHERE film_id = p_film_id AND store_id = p_store_id AND NOT inventory_in_stock(inventory_id) INTO p_film_count; END