MySQL Forums
Forum List  »  Stored Procedures

Re: Need to understand a MySQL Procedure
Posted by: Peter Brawley
Date: August 23, 2014 09:44PM

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

Options: ReplyQuote


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.