sakila
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
inventory_held_by_customer
Parameters
Name
Type
Mode
p_inventory_id
int(11)
IN
Definition
BEGIN DECLARE v_customer_id INT; DECLARE EXIT HANDLER FOR NOT FOUND RETURN NULL; SELECT customer_id INTO v_customer_id FROM rental WHERE return_date IS NULL AND inventory_id = p_inventory_id; RETURN v_customer_id; END