android电子点餐系统
于 2022-08-09 发布
文件大小:2.68 MB
0 172
下载积分: 2
下载次数: 1
代码说明：
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
下载说明：请别用迅雷下载，失败请重下，重下不扣分！
发表评论
