1 2 3 4 5 6 7 8 9 10 11 12 13 14
delimiter // create function get_invoice_price_info(i_invoice_id INT, bruto_price DECIMAL) returns char(1) READS SQL DATA begin select sum(ii_amount * ii_price) into bruto_price from invoices inner join invoice_items on ii_invoiceid = i_id and i_id = i_invoice_id limit 1; return 'a'; end // delimiter ;