PL/sql
delimiter $$
create procedure updateItem(poid int)
update
t_orderitem
set
paymentstatus=1
where
orderid=poid
end$$
