Description

The film_in_stock stored procedure is used to determine whether any copies of a given film are in stock at a given store.

Parameters

Return Values

This procedure produces a table of inventory ID numbers for the copies of the film in stock, and returns (in the p_film_count parameter) a count that indicates the number of rows in that table.

Sample Usage

mysql> CALL film_in_stock(1,1,@count);
+--------------+
| inventory_id |
+--------------+
| 1            |
| 2            |
| 3            |
| 4            |
+--------------+
4 rows in set (0.06 sec)

Query OK, 0 rows affected (0.06 sec)

mysql> SELECT @count;
+--------+
| @count |
+--------+
| 4      |
+--------+
1 row in set (0.00 sec)