Re: Need to understand a MySQL Procedure
The func implements this logic ...
( select count(*) from rental where inventory_id = p_inventory_id ) = 0
or
( select count(rental_id) from inventory left join rental using(inventory_id)
where inventory.inventory_id = <SOME_VALUE> and rental.return_date is null ) > 0
Subject
Views
Written By
Posted
2731
August 23, 2014 06:33PM
Re: Need to understand a MySQL Procedure
1119
August 23, 2014 09:44PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.