android电子点餐系统

CREATE PROCEDURE `new_proc`(IN tableId1 INTEGER(11), IN tableId2 INTEGER(11))     NOT DETERMINISTIC     SQL SECURITY DEFINER     COMMENT "" BEGIN      declare perNum,oId1,oId2 integer;           select personNum  into perNum from OrderTbl as ot where      ot.tableId =tableId2      and ot.isPay = 0;           select id into oId1 from OrderTbl as ot where      ot.tableId = tableId1      and ot.isPay = 0;           select id into oId2 from OrderTbl as ot where      ot.tableId = tableId2      and ot.isPay = 0;      update Order