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
下载说明:请别用迅雷下载,失败请重下,重下不扣分!