CREATE DEFINER=`root`@`localhost` PROCEDURE `testingtwo`(in plato integer, in payment decimal(8,2))
BEGIN
declare   pay decimal(8,2);

update patron set fines_owed-payment where patron=plato;

-- update patron set fines_owed =newfines where patron_id=plato;

select concat(efname,'  ',elname) as borrower,fines_owed from patron      where patron_id=plato;


 END